Exporting to multiple sheets in a single Excel Export

Packages
1

I’m trying to combine 2 different excel export graphs into a single graph by way of 2 different sheetnames under the shared single new excel file path. They previously worked as 2 independent dynamo graphs exporting to 2 different excel files. When I try to combine them into one graph that exports to 2 different sheets within the same new excel file, only one sheetname gets created.
I tried doing combining the two of them into 1 consolidated sheet using list.join but that didn’t work either. Please see below. Any guidance from the community is greatly appreciated. Thanks.

image
Revit2016_Dynamo1.3_ExportDWGLinksImportsList RevitLinks_toExcelWithoutOpeningRvt.dyn (18.3 KB)

1 Like
2

Hi @daniel.tran,

The Passthrough node from Clockwork allows you to decide the order of the operations.

Solution 1 = 2 Sheets :

Export%20solution%201
Export solution 1.png5162×1248 516 KB

ExportDWGLinksImportsList RevitLinks_toExcelWithoutOpeningRvt Solution 1.dyn (27.4 KB)

Solution 2 = 1 Sheet :

Export%20solution%202
Export solution 2.png5558×1248 452 KB

ExportDWGLinksImportsList RevitLinks_toExcelWithoutOpeningRvt Solution 2.dyn (23.0 KB)

3 Likes
3

Solution 1 = 2 Sheets worked for me!!!
Thanks so much

4

quick question: In Solution 2=1 Sheet, what is the code block node with " "; for?
Why wouldn’t you just have the 2 lists going into the List.Join node?

image
image.png802×602 44.9 KB

5

The codeblock adds a blank row to separate the CAD and Revit files in the Excel worksheet.

1 Like
6

You can use a Bumblebee package like so:

image
image.jpg1139×466 67.7 KB

That will write the values to two (2) sheets at the same time without having to access the Excel file twice.

6 Likes
7

This works great! If I’m creating new worksheets with new names, is there a way to delete the default worksheet called “Sheet1”?

Thanks,
Scott