I would be most grateful if you could assist with the following:
I am trying to write an algorithm (don’t know the correct jargon?), to take parameter values from an Excel sheet and import it to Revit.
There are 10 instances of the family, each with approximately 45 instance parameters. I’ve opted to have one type of family with instance parameters, as opposed to having 10 types of the same family, with type parameters, although I don’t know which would be better?
The main issue is linking each Excel cell to its relevant Revit family instance parameter leaving me with 400 cells to assign, as opposed to running a type of “for loop” which would divide that number by 10.
Please view the images attached and let me know if you have any recommendations, simplifications or advice you could share. (The values for the different instances (defined by columns) are mostly identical here, but would by different in real scenarios).