Export and Import Revit Data to Excel using Dynamo
ฝัง
- เผยแพร่เมื่อ 6 มิ.ย. 2015
- This tutorial shows you how to use Dynamo to create a two-way link between Revit and Excel.
Want more Dynamo? Sign up for my free course, "Dynamo for Busy People". Get 5 useful Dynamo scripts plus an annotated screenshot showing how I created it.
Sign up here: www.archsmarter.com/dynamo-busy-people
![[TH] VCT Pacific Stage 2 - Playoffs Day 3 // DRX vs GEN | PRX vs TLN](http://i.ytimg.com/vi/CWM1Q-2-o3M/mqdefault.jpg)
You speak clearly and articulately, and there is no distracting background noise. Excellent video. Thank you for sharing.
I've been looking for hours of a decent how-to video that actually explained why one is connected to the other. Your video help me tons! Thank you!!
Probably the best teacher of Dynamo I've watched on youtube. You not only show us how it works, but explain to us in a clear manner on why it works that way.
Thanks for all the tips and advice!
Thanks Robert! I appreciate the support.
this is one of the best online tutorials i have ever seen, very clear and concise
Thanks a lot I can't stop thinking about all the applications I can make with this tutorial. Great job and thanks for sharing.
Thank you so much for sharing this. This is a very helpful and clear tutorial.
Congrats!!! Clean and simple!!! well done!
Very useful data and I really appreciate the way u explain it.....Thanks a Lot
Great video, helped me alot to get the hang of exporting to excel. Thank you.
Hey, great class at RTCNA this year! Glad to meet you, keep up the good work!
Thanks Ryan! It was great to meet you as well.
You are a lifesaver for my Dissertation! Thank you
same here
Thank you for Sharing. This is very helpful. Excellent Dynamo tutorial!
very helpful for beginners hope a few more videos from you thank you very much
Great vid Michael very helpful thanks
Great tutorial! Thanks! More dynamo tutorials please!!! :)
Very well done sir. This is the first step in a bigger project I have taken on, thank you for the outstanding tutorial.
+Michael Dulberg My pleasure! Happy to help out. What's your project?
+ArchSmarter I am a BIM Engineer for my company. Our estimators are in need of a much faster and streamlined process. I'm looking to utilize this as a base point for a more specific script that will allow location based model quantity numbers.. sq. ft. of X at Y location, or linear sq. ft. of X on floors 4-12... etc.
thank you for this information Michel
It helps a lot . Thank you .
this video was so precise to my requirement
thankyou.
Brilliant. Thank u
Thanks a lot.
Thank so much
Thank you
Excellent tutorial, I get similar errors but managed to overcome the issues. Only thing is that phone in the silent mode was distracting.
thaks, is realy grate your tutolual. I have a problem, in i want to actulice revit plant i need to desconet and conect ths File from path node. I dont know why
Perfect video! but one question, how can I apply this to type parameters? I only can do it with instance parameters
Thanks sir
Hi Thanks for Video. It was really helpful. But for just an update "Write to Excel" node in Dynamo is not longer working. It has some issues to fix.
Thanks for the video...when I choose file path (13m15s in the video) dynamo crashes and close suddenly.Any idea abaout why this is happening?
where can you find all the possible parameters for rooms? Instead of writing them as a string is there a way to select them from a list?
Thank you for the tutorial. I have tried this, with Specified Airflows, and when I change anything in Excel, and re-run the code, it re-writes the excel with the Revit information instead of writing from excel to Revit. Any ideas? Thanks
Any idea to select parameter name , no need to type parameter exactly into string node ?
How would this work with elements that share some parameters? Such as conduit?
i have done this for doors in my project, but i'd like to short doors by doors number , could you teel me how ? great video btw
This is great. My 2 complaints are there are no headers and the export doesn't list in the correct order. I am not sure what is happening with that. For example if I have 101, 102, 103 104 and 105, the order in excel is 101, 102, 104, 105, 103.
I am using Dynamo 1.3.2, with Revit 2018. My List of Rooms seem to be dropping off. Can't seem to past a pic.
extreme well
is it possible to sort the output files according to eg "name, level, etc"?
I want to change type parameters in structure elements. Is it possible? I've made the same thing you did but I can't even get the family's name.
hi is amazing your work i would like to know if you have a course about API for sub disipline Electrical
thanks
is there a way to get the rooms position?
HI. I Have structural column loading data in excel format. how to bring into a my revit project file thru Dynamo
More tutorial videos required. Greetings from Russia!
What about the sequence in which dynamo reads the elements? When you have like 30 rooms wouldn't it be all randomized in excel?
Abner Jr. Paredes The order of rooms in the output to Excel is based on when they were created in Revit. It is possible to sort them in Dynamo before exporting them.
Check out this video for how to sort lists by parameter values:
th-cam.com/video/2pVQICECE1c/w-d-xo.html
DWG to Pipe fitting can you explain it once.
is it possible to edit a schedule been made in revit and modified itu using dynamo and revit?
This video is really awesome. Thank you so much for sharing it.
Just one question. Is there any way we can do this without opening dynamo? For example, made some changes in Excel and automatically reflect those updates in Revit without loading dyanmo.
I understand dynamo is the key here but I am wondering if there another way.
Sorry, there's no way to run the script without opening Dynamo. You could use a macro or add-in, but that's a different issue.
Can someone help me in telling that how can we know if the modeler has performed the specific task given to him by client. Any leads will be appreciated.
this is great, you can export " NODES" to exel ?
NO
Hi, is it possible to create a true bi-directional link between Revit and Excel using this method?For example, change a window size in Revit, run the Dyn graph and it updates in excel. Change the same number in Excel, run the Dyn graph and the window changes in Revit. I've tried, but to no avail.
Any luck?
dude would like to know also actually :D
Hey, great tutorial!
I would like to know if it´s possible to use Dynamo on a revit project which is set up on A360. Its basically a shared model, where several person are working on. Would every single person need dynamo? And is it possible to save the excel sheet on dropbox or similar cloud tool and keep the linking in both way working?
+Eva Chan I haven't tested Dynamo with A360 but it should work. Dynamo links to whatever is the active file in Revit. I don't think an A360 file would be any different than a file on the local computer, as far as Dynamo is concerned. Every person would only need Dynamo if there were going to open the graph and run it. Unless every person's local path to their Dropbox folder is the same, I suspect everyone would need to remap the filepath to the Excel file. Good questions! I'll do some testing on my end.
+ArchSmarter Thx a lot! My team will try it out as well.
Eva, did you guys have success in working with it in A360?
LibreOffice? why not?
HI. Room names are not showing. only numbers are visible. pls advise
И что в итоге? Каждый раз писать в динамо на любую спецификацию?
How can type parameters be imported? as Type description
Check out this video: th-cam.com/video/zbLykm8nqa0/w-d-xo.html
I walk you through the process of getting type parameters using Dynamo.
Good luck!
My problem is to import the type parameters, like description, Thanks for de Video
I am trying to solve a BIM programing problem for my firm. The want me to make their Program questionnaire read from excel and import the data into revit scheduling and control a block diagram. I have followed your steps and continuously get an error. it is frustrating. can you help me solve this issue by this afternoon? the pressure is on.
Christopher Smith What type of Revit element are you using to represent the block diagram? Mass families?
I was using a generic model with parameters I set into therm.
i can forward you the file if you would like?
Yes. I'll take a look. You can email it to michael at spacecmd dot com.
In this function, Dynamo is a litle bit more complicated than other addins which I have been using to link Revit and Excel
Like what?
hi, can you help me with the error:
Aviso: Excel. Falha na operação WriteToFile.
Não é possível converter o objeto COM do tipo 'Microsoft.Office.Interop.Excel.ApplicationClass' na interface tipo 'Microsoft.Office.Interop.Excel._Application'. Esta operação falhou porque a chamada de QueryInterface no componente COM para a interface com IID '{000208D5-0000-0000-C000-000000000046}' falhou devido ao seguinte erro: Erro ao carregar a biblioteca/DLL de tipo. (Exceção de HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
the excel file doesn't even open, everything is working flawless on the others steps. thanks
What version of Excel do you have installed on your computer?
ArchSmarter all office is 2007 and the Windows is the 10 Pro.
Take a look at this post. It should help: github.com/DynamoDS/Dynamo/issues/5925
its not funny, its buggy