That node is a little more complex. The use case for this was the following. If you have a nicely formatted sheet in Excel, with graphics, and merged columns etc. none of the Excel export nodes are very good at writing to seemingly random cells. So what I came up with was a workflow where I just dump all data to one sheet (“Data”) and then reference these values in the “Template” sheet. That way I can simply dump all data in a single row or column, and my pretty template will be populated via references. With that being said, to get this to work you need to:
Specify Template File Path. That’s an empty Excel file, that has two sheets: “Template” and “Data”.
Folder that new files will be saved in. Imagine feeding in data for multiple rooms, and expecting to generate a new Excel file for each room (room data sheets). They will be saved in this directory.
New file name for each file that will be saved out. In my use case I was doing RDS sheets so i used room name/number + .xlsx to create the file name.
The actual data. It should be formatted in this manner List[][] or [[data], [data1], [data2]]. Basically nested lists where each sublist refers to new excel file.
Remember the first input? Template and Data sheets have to be two worksheets so they might have different names. Specify these two. They cannot be the same sheet.