Second topic here. I would like to write data from Revit through Dynamo into an Excel document. However, I would like to retain formulas and column headers in the destination document, if possible. I am seeing the process wipe out rows containing column headers even though they are before the assigned start Row number. I am also seeing data links which reference cells on this sheet be broken when the data is written… I can only assume it is re-creating or re-naming the individual sheet when it writes the data and so the link is lost. Anybody have any workarounds here?
Specifically, I want to user Revit for ventilation schedules, but since Revit can’t handle pulldowns or lookups in formulas, I am trying to bounce the data through Excel so that an engineer can do that part efficiently. Open to any ideas or suggestions!