Export Revit schedules into one Excel spreadsheet and separate sheets/tabs

[alar.hammer]

Hi. I am new to Dynamo but eager to learn
Need help with script. Would like to modify it so each schedule gets to it’s own tab/sheet in excel. Also the Text to filter option does’nt work correctly.
Thanks!!

Schedules%20to%20Excel%20question|690x275

Schedules to Excel sheets.dyn (9.5 KB)

[Thomas_Corrie]

Take a look at this thread:

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

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]

ScheduleView.Export supports csv, tsv etc which in turn only support single sheets. The alternative is to use Bimorph nodes to get the data from the schedules and then export to Excel