Manage Excel rows from Dynamo


#1

Hi all!

I have made a Dynamo graph that filters and reads a bunch of parameters from some elements in Revit and writes them to a template Excel file in the correct sheets, rows and columns. So far I have made several blank rows under every point in Excel to collect the incoming data. I would like to use this as a routine for many projects. My problem is that different projects have different elements count and sometimes the blank rows that I made are not enough and Dynamo overwrites the headers of the next points in Excel. And if the elements are less in count than the rows that are available someone has to manually delete the unnecessary blank rows.

Is it possible to tell Dynamo to create as many rows as it needs under every point in my Excel template file? Or maybe I should search for solution not in Dynamo, but in Excel? Any suggestions?

Thanks