Dynamo Shorts - Ep009 - Export Sorted Data To Excel 

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

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

Amazing, thank you!

Thanks Dana, great explanation

Thanks Dana, you did great on the explanation

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. :)

Wow Nice

thx 😜😜

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?

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!

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