Export excel schedule not behaving as expected

Revit
,
1

Hi,
I can’t figure out what i’m doing wrong.
Trying to export an excel of a schedule from elements in my revit model.
The lists seem to be previewing ok in dynamo, but the list gets messed up in the Export to excel node and the file comes out all messed up.
I’m trying to pull parameters from my elements and output a cutting schedule to excel.
This is the workflow i’ve used:

  1. Pick element
  2. Get element category
  3. Get parameter value by name
  4. Create 2 lists- one is just header titles and the other is the values
  5. Flatten and transpose lists
  6. Combine lists by list create
  7. Export to excel

Can’t pinpoint what i’m doing wrong, this is my first script in dynamo!

Capture

2

2018-06-07%2009_40_54-blox%20scheduling%20test8%20-%20Saved
2018-06-07 09_40_54-blox scheduling test8 - Saved.png1519×642 12.7 KB

3

Your data list is not formatted properly. The list can only have 3 levels. You need to add your headers as a single item to the front of your data list before exporting to excel.
image

1 Like
4

Fantastic! That helped, Thank you for the quick solution.