I’m looking to write from an excel document provided by a contractor into Revit and have not had much success thus far. My ideal scenario is to have dynamo perform the following logic:
Load Excel Data -> Compare Excel and Revit Data -> find areas where the data sets match -> at each match pull additional data from Excel to populate additional parameters.
In this instance I have a spreadsheet that contains a list of unique Device Numbers and then a series of other parameters per fixture. Our Revit flie has devices placed and the Device Number parameter is populated. Is there a way to have dynamo comb the excel data to find where excel device numbers already exist in Revit, then populate additional parameters values from the same excel sublist (in this case horizontal rows)?
The lists will be unequal, the excel having many more fixture numbers than will be present in the model, which has been a barrier to simply reading and writing en-mass.
I can’t share the data set unfortunately as it contains company information but I will attempt to a simple placeholder and my early efforts below.