ExcelPlus: writing multiple worksheet of the same workbook

Grasshopper
,
1

excelPlus.zip (41.7 KB)
Hello everyone,

I’m automating an Excel export in Grasshopper using the ExcelPlus plugin. I have four output lists in GH that need to land as four contiguous columns in every worksheet of my target workbook:

  • Output 1 should start at G4 and fill down
  • Output 2 should start at H4 and fill down
  • Output 3 should start at I4 and fill down
  • Output 4 should start at J4 and fill down

Example files attached

  1. source.xlsx

    • Contains sheets named “TR-32-1”, “TR-32-7”, “TR-32-12”, etc.
    • In each sheet G3:J3 you’ll see headers DATA 1 | DATA 2 | DATA 3 | DATA 4.
    • I’ve removed the actual values for privacy, so G4:J… are blank but the structure matches my real file.

  2. desired_result.xlsx

    • Shows exactly how each sheet should look after the export, with the four columns populated from G4 through J4.

What I’ve tried

  • Write Worksheet with “Use Branch Paths as Sheets” + “By Columns = true”
    • Issue: It treats each branch as one column, so I end up with 4 columns in a single sheet (branch 0) instead of one sheet per branch.
  • Entwine to bundle my four lists into sub-lists before writing
    • Still can’t get ExcelPlus to split them into columns G–J in each separate sheet.

Questions

  1. How should I structure my data trees so that ExcelPlus creates one worksheet per branch (0…n) and writes my 4 GH lists into columns G, H, I and J starting at row 4 in each sheet?
  2. Is there any specific setting or workflow in ExcelPlus (or an alternate component/snippet) that I’m overlooking?

Any pointers, component suggestions or GH code snippets are greatly appreciated.
Thank you in advance!