My script writes values to room parameters from Excel. Works OK but some unpredictable results makes trouble shooting hard. In a nutshell, I don’t know how the Element ID node input to the Element.SetParameterByName node correlates with the values input from Excel. I think I need another set of nodes between the Excel.ReadfromFile Node and the Element.SetParameterByName to correlate with the Element ID node.
The Excel sheet was created using Dynamo to write Revit room parameters to Excel. I think the reason it appears to be working is that I am reading and then writing the elements in the same order, but just by coincidence.
For instance, how do I get Room #101 to always be named, “Classroom”; it seems like I could easily change Room#101 into “Closet” and never notice.
Thanks for any tips