Import Excel Into Revit using dynamo

Anonymous — Wed, 02 Aug 2017 09:03:31 GMT

Hello.

Im a new user of dynamo and would like to import an Excel schedule into revit, using dynamo.

i cant figured out what im missing in this dynamo, or if there is another way to do this?

ive detached my dynamo, excel and a revit schedule ive created as a key schedule.

thanks on beforehand

Re: Import Excel Into Revit using dynamo

rudi.roux — Wed, 02 Aug 2017 10:04:12 GMT

Hi @Anonymous,

Welcome to the community!

A few comments which I have with regards to your post, it looks like you created a Revit Schedule with "dummy" parameters which will then be used to read the info from Excel, with various grouped/merged headers.

I would firstly use Shared Parameters as the "dummy" columns in your schedule, then you can either use Dynamo or a Add-In from BIMOne to read and write data between Revit and Excel. If the data needs to read from elements in Revit to Excel and then back by means of using Dynamo, then an important thing to do is to export the GUID of each element along with the rest of the data with Dynamo and then edit content in Excel and read the data back into Revit.

Here is a VIDEO which you can watch which will help you.

Here is a POST with pictures on the DynamoBIM Forum which will help you.

Here is a link to the BIMOne Addin which I talked about.

Each of the aforementioned will assist you, if you're still struggling after going through the above-mentioned solutions, then I would use the DynamoBIM Forum and post your Dynamo Script along with a sample Revit and Excel file there. The "Python Script" Node which you are currently using is currently holding you back.

I hope this helps!

topic Re: Import Excel Into Revit using dynamo in Revit MEP Forum

Import Excel Into Revit using dynamo

Re: Import Excel Into Revit using dynamo