How do I import Excel into a schedule in Dynamo?

How do I import Excel into a schedule in Dynamo?

dice-shunpei_chiba
Participant Participant
3,050 Views
6 Replies
Message 1 of 7

How do I import Excel into a schedule in Dynamo?

dice-shunpei_chiba
Participant
Participant

I want to edit the Excel data exported from Revit in Dynamo and import it into Revit, but I can't do it well. I'm a beginner, so I've been trying it while looking at various things, but I don't know the solution, so if you are familiar with it, please help.

(dynamoでrevitから書き出したエクセルデータを編集してrevitに読み込みたいのですが、上手くできません。初心者なので色々見ながら試していましたが解決法が分からないので詳しい方いましたらご助力願います。)

diceshunpei_chiba_1-1717393563468.pngdiceshunpei_chiba_2-1717393580316.png

 

0 Likes
Accepted solutions (1)
3,051 Views
6 Replies
Replies (6)
Message 2 of 7

scgq425
Advocate
Advocate
Accepted solution

@dice-shunpei_chiba :

You code is ok , if the function cant run or result error , u need to check u elments result . i copy u function in my dynamo , is ok . so check the result or give more information of this problem.

scgq425_0-1717397977998.png

 

LanHui Xu 徐兰辉
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

Blog
LinkedIn
Revit/CAD Development | Steel Product Manager

EESignature

Message 3 of 7

dice-shunpei_chiba
Participant
Participant

Thanks for the reply. If you check closely, the category to be input to Element.SetParameterByName is a summary table, and when I changed this to mechanical equipment, it worked.

diceshunpei_chiba_0-1717399433550.png

 

0 Likes
Message 4 of 7

scgq425
Advocate
Advocate

In u Picture , the paramater name is 'LIST' , May be this paramater is unvaild 

LanHui Xu 徐兰辉
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

Blog
LinkedIn
Revit/CAD Development | Steel Product Manager

EESignature

0 Likes
Message 5 of 7

dice-shunpei_chiba
Participant
Participant

The parameter I wanted to get was equipmentname. When I changed it to this and executed it, I was able to change the Excel value normally. Also, if you have any questions, please help us.

0 Likes
Message 6 of 7

scgq425
Advocate
Advocate

im happy to help ur .

but , i cant understand u idea , u want to get equipment name or change excel contains import and export ?

u can post a sample project or some picture .

LanHui Xu 徐兰辉
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

Blog
LinkedIn
Revit/CAD Development | Steel Product Manager

EESignature

0 Likes
Message 7 of 7

scgq425
Advocate
Advocate

In This , i make a function to input value to excel and export value to excel , ur can run this and tell me which error or run success .

Sample.png

LanHui Xu 徐兰辉
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

Blog
LinkedIn
Revit/CAD Development | Steel Product Manager

EESignature

0 Likes