Just a quick one really.
Using the provided Excel.WriteToFile node, can I use the ‘StartRow’ and ‘StartCol’ input fields to put in sub-list data?
Example:
I have room names I want to put as the first row coming in as a list from 0 - 114.
I have room areas derived from each wall coming in as a sublist. 0-114 correlates to the room above, while the ‘walls’ within each of those ‘rooms’ have their own sublist. These sublists vary completely. Room 29 has 7 inputs (0-6), room 51 has 31 (0-30).
I want to be able to associate in Excel the room name from the first input with the room areas from the second, and have each area populate it’s own row while remaining in the correct Room Name’s column.
So my query is:
Do I have to combine the lists (Name and Areas) to create one list to parse out to Excel? Or can I use some funky code block input to allow my sub-lists to parse out correctly? And if so, any tips?