Export to Excel multiple columns and sheets

Hi,
I’m trying to export list data to multiple columns and sheets in excel file, but the excel is going crazy… (opening many many times, trying to oversave itself, trying to create temp. excel files etc.)
I suppose it’s because of me calling multiple times to export data? Should I group lists and sheets in one big list with sublists and feed that to single Data.ExportExcel node ?

hi @atis.sed

the short answer to this question Should I group lists and sheets in one big list with sublists and feed that to single Data.ExportExcel node? is Yes.

You can save multiple excel sheets in dynamo in one line/node only.

-biboy

2 Likes