Multi sheet excel export


#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.

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.