Revit Dynamo Excel Export to Separate Sheets

Revit
1

Hello, everyone!

I would like to put together a Dynamo script that can gather information about different rooms and then export the information about each room into separate sheets in a single Excel file. A master file for all Room Data sheets in a project.

I am new to Dynamo so I don’t know if there is a node or a collection of nodes that could help me achieve this.

Please see images of what I want to achieve in Excel and my initial attempt in Dynamo.

Room Data Sheet Example - Each room has separate sheet: https://imgur.com/7f96ja2

Dynamo attempt: https://imgur.com/j3Mb8qI

I am thinking that in order to achieve a similar layout, I can break it down into smaller tables and set their origins separately in Excel. Anything beyond that, I don’t know. I did think of making a set of nodes for each room to be exported into its own sheet, but then where’s the automation?? :smiley:

Any help on the matter will be greatly appreciated!

2

Combine each of your data sets into a single list and input a list of names into the sheetName input like this:

image
image.png1312×568 44.9 KB

Note that the sheetName input is at level 1 and the data input is at level 3.