How do I target a particular object (aka instance) for importing data from an Excel spreadsheet.
Suppose I have a project with multiple rooms and one of the parameters is room name (e.g., Kitchen, Conference Room B). Further suppose I want to create a spreadsheet of room names. How would I use Dynamo to assign each room name to the appropriate room object, so that, for example, a kitchen is not named Conference Room B?
One approach is to assign a permanent unique identifier to a room when it is added to the Revit project and use that same ID in the spreadsheet. This ID could be something as simple, and unique, as a room number. Then create a Dynamo script (aka graph) to import the room name into the correct room object, per the room number. How would I implement this approach with a Dynamo script?
Let’s suppose the spreadsheet is:
… 101 … Kitchen
… 102 … Conference Room B
Of course, there may be other, more suitable, approaches.