Push Edits from Excel back into Revit

revit
excel

#1

All,

I apologize if this topic has already been covered. I am somewhat new to Dynamo and may not have been searching the optimal terminology to find any previous post on this topic.

The problem: I am looking for a way to push data that has been updated in an excel spreadsheet back into a Revit model using the element ID as a primary key.

Question: Is there a way to create a visual code that basically says "If components element ID in Revit matches a value in the element ID field (column), then use values in that row of data to update other fields in Revit (e.g. Room Name, Number, etc.)

Also, Would I have to build a separate script for each category (rooms, doors, MEP equipment, etc.) or is it possible to build a code that searches all element IDs in a project.

Thank you for your help.


#2

This has been covered in significant detail… Look for select by element id.

Note that Element IDs aren’t necessarily static.


#3

Check out the workflow displayed here for a start.

I would suggest that you spend some time ‘trawling’ similar posts that have mentioned “excel link” :slightly_smiling_face: