I am looking for a way to form a Dynamo script that ensures that values which are red from a spreadsheet are assigned to the object it is meant for, but I need a little push in the right direction.
I have a Revit project that has several objects (wall, beams, columns and so on), but for this example let us say that my project just contains 10 walls. Each of them is given a unique ID: E.g. Wall-1 to Wall-10. Now I use Dynamo to export the information about these walls to an Excel spreadsheet, and then I send the spreadsheet to a co-worker. He updates the values and send it back to me. And when I want to import the values into my Revit project from the spreadsheet, my problem appears: What if I have made changes to my model (added, deleted or splitted walls) in between my co-worker gets the spreadsheet and sends it back to me , how can I be sure that Wall-3 gets the info for Wall-3 from the Excel sheet and not the info for Wall-4? I have experienced that Revit can change a wall’s position in a list when changes have been made. So, I want a code where I can be a 100 % sure that values are assigned to the correct object.
I think the solution might be to sort both the Excel list and the Revit list by my unique object ID. But I haven’t been able to find a working code for this yet.