No dynamo experience. in need of help

Revit
,
1

Hi there,

I’m pretty new to dynamo and I’m just wondering if anyone can assist me in creating a script to export element parameters in a table format to an excel file? I’ve scoured the tutorials on youtube and on google and couldnt find the one im looking for. technically i can just export a multi-category schedule to excel without dynamo but i’m looking for a way automate it without creating a schedule. I’m looking to create an export file like this. i can add more parameters if needed. Help is appreciated. Thank you

02 - ResearchProject_ExportedRevitToExcel
02 - ResearchProject_ExportedRevitToExcel1417×728 44.1 KB

2

I guess you didn’t search on these forums. :grinning_face_with_smiling_eyes:

https://forum.dynamobim.com/search?q=export%20excel

3

The script below is used to export information for all categories used in the project.

Export Infomations.dyn (52.0 KB)

4

thanks for your replies. I’ve already did see this previously but couldnt find anything specific. I’m trying to stitch this parameter data to PowerBI

5

Thank you for your help. apologies i’m a complete beginner here so i may have missed some things. i’ve tried to run the script but it gave an error in the code block which has a.Name; in it. it asked to convert non-convertible types? and on the last block (Dat.OpenXMLExportExcel it says could not load file or assembly documentformat.openXML. The only thing i know what to change is the file path. guidance is appreciated. Cheers

6

Engage with the dynamo primer. Dont skip the basics.

1 Like
7

I’m 100% sure you will find something on this forum- I suggest reading through related posts *, even if they are not exactly the solution you want, they will help you understand what you need to do (as well as the primer suggested by @GavinNicholls )

*exporting data to Excel is probably the most common use-case for Dynamo, or at least where many people start

1 Like