How to save a Revit Schedule to 'Sheet1' in excel

1

Hi

The attached script creates a new excel file, and that was originally fine, but what I want to do now is transfer this onto ‘sheet1’ in an existing excel file. Please can you assist (ive spent a couple hours trying to do this but with no success).
Many thanks in advanced.

1
1.PNG1635×630 94.9 KB

2

The limitation here is that ScheduleView.Export supports delimited file types like CSV or TSV, which don’t support multiple sheets.

One method would be to use BimorphNodes Schedule.GetData node to get your schedule as a nested list. Then feed that to Data.ExportExcel which allows you to specify a sheet in the Excel file

image
image.png2680×938 185 KB

2 Likes
3

I cant seem to find that Schedule.GetData. Please can you highlight where this is please

4

It’s from the BimorphNodes package: https://bimorph.com/bimorph-nodes/get-schedule-data/

image

1 Like
5

Excellent work, now how can I input 2 revit schedules into the same Excel sheet, one on Sheet 1 and the other on Sheet 2? Without creating two dynamo scripts? Thanks in advanced.

1
1.PNG1528×417 66.9 KB

6

The number of sheets is equal to the number of data

Capture
Capture.PNG481×794 39 KB

1 Like
8

I managed to get round to doing it like this. Thanks all for your help :slight_smile:

1
1.PNG1640×625 117 KB

3 Likes