I’m working on a Dynamo script to export data regarding which rooms contain which types of lighting fixtures and their respective counts. While I’ve successfully gathered all the necessary data into a list (Refer dynamo snip), I’m encountering difficulties in formatting and exporting this information into Excel.
I aim to achieve an output similar to the following.(refer excel snip).
Any guidance or suggestions would be greatly appreciated.
You have some Formatting Issues, and some List-Issues.
I recommend flattening the list @L2.
For each list, you should have 6 items.
1 Like
Excel data follows a specific structure: a list of sublists. Each sublist represents a row and each item in that sublist represents the cell’s value at that index. You need to format your data to match that schedule. That means including blank strings where you have blank cells in a row.
2 Likes