I’m currently working on developing a workflow which runs as:
• Cells are manually filled in excel by the user. This data is sent to a stream which is automatically received through the receive node in GH.
• A GH script runs when this data is received and then automatically sends 12 lists of new data to a different stream through the GH send node.
• This data is then imported to a separate excel sheet.
The workflow works as a concept right now but I’d like to make the import of the GH data into excel quicker for the user.
I’m currently sending 12 separate lists from GH, which must all be individually imported. This only takes 1-2 mins but ideally would love if this data could come through in just one click. I’m aware I could add all the data into one list in grasshopper but then all twelve lists are imported as one long horizontal list in excel. The tool also works in such a way that the lists don’t remain the same length each time, so not easily fixed with a macro (although this would be possible, not the most ideal solution.)
I was wondering if anyone knows of a way to import multiple lists into excel, in one go, but in a way that each list starts in a new row?
If this isn’t currently possible, I think this would be a hugely beneficial update to the connector.