This is the second post in a series of 3 about linking Revit to Excel with Dynamo. Click here to download the entire series in PDF format, along with 2 dynamo scripts.
In this post, you will learn how to create a Dynamo script that pushes information from Excel to Revit.
In this scenario, we imagine that a project manager updates a spreadsheet with room information. The BIM manager needs to push this data to Revit. In addition, we have more requirements:
The script should work with any project.
The data might not always be in the same order.
That means the Name column might sometimes be in column 1, sometimes in column 2, and so…