Dynamo Shorts - Ep009 - Export Sorted Data To Excel

On this episode of #DynamoShorts we will export the parameter data of a category of elements to Excel! In the example I show #roomData exported from the #AutodeskRevit sample file to #MicrosoftExcel through #DynamoForRevit! The rooms are sorted by Level and Room Number then the Element ID, Level, Name and Number data of the sorted list is exported.
Video on List Levels: • Dynamo Shorts - Ep005 ...

[@cathychoi6959]

Dana your tutorial keeps me awake at work the moment and Live the way you teach! thanks🤣

[@caretspace2646]

This was an excellent and to the point content, Love the way you explained. Thank You so much.

[@MattSal88]

Love Excel exports! I tend to throw them into most of the scripts I make 1) because they're useful but also 2) because setting the file path as an input will force Edit Inputs to open in Dynamo Player every time (aka idiot-proofing).
I like your method too, but I've always found it easier to just create a separate list of the column headers off to the side and to use AddItemToFront once I have my final, transposed list of spreadsheet data. I find this helps keep the actual row data cleaner and more organized throughout the graph.
Cool stuff though, as always. :)

[@DanamoBIM]

Love these tips!!! Thanks Matt!!

[@Fernando-zl6ff]

Thanks Dana, great explanation

[@borland258]

Thanks Dana, you did great on the explanation

[@datguy729]

Amazing, thank you!

[@suppakornngantaweekit6491]

thx
😜😜

[@elevenbim]

Wow Nice

[@bryantr8370]

You used two parameters to sort them by. What if I wanted to add another parameter to sort them by. Therefore, a total of 3 parameters instead of 2. How can I continue to add more essentially?

[@DanamoBIM]

added to the list of videos! thanks @Bryant!

[@bryantr8370]

@@DanamoBIM Awesome!! Thank you!

[@jorgeloaisiga3348]

Can you share all the packages you're using? I'm new to Dynamo and don't see many of the functions you're using. Thanks!

[@DanamoBIM]

I do not use any nodes that do not come with Dynamo. No custom packages in use :)

[@AJR-gg]

I had my list set up, exact same as yours with Transpose at the end, but I'm getting a "Warning: Data.ExportToExcel operation failed" message.
The Data.ExportExcel Node in my version of Dynamo is called Data.ExportToExcel and has an extra input called "writeAsString", It's default set to false but I tried both true / false and had same outcome.
Any ideas? Thanks

[@melanielavoie7787]

I got the same error, not sure what I missed! @DanamoBIM

[@AJR-gg]

@@melanielavoie7787 Hey, I got the same issue. I already replied to your comment with a solution but it got deleted for some reason, maybe because I posted a link a dynamo forum.
Use the Data.OpenXMLExportExcel node instead of the Data.ExportToExcel Node and change the file path to a string.
I made a forum post about it on forum dynamo bim titled, Dynamo Data.ExportToExcel Problems.