Multi sheet excel export

Packages
1

Hi all

I try to make a script that will send several information to Excel. My need is to be able to send different information to different sheet in excel.

I am able to let excel create several sheets, with different names, by using a list of strings. However, the result is same data on all pages I excel.

In the example have I tried with the first element in a list of several categories.

multisheet
multisheet.jpg1821×485 218 KB

Thanks in advanced for you help.

2

Feed The list of sheet names and the list of data arrays into a List.Combine node with two In lists. The Excel.WriteToFile node will be fed in as the function with the data and sheet ports left open.