Formatting Excel Headers

[frank.v.smith]

Hello! New to Dynamo so I’m not totally sure if I’ll explain this correctly. Essentially I have a script that creates an Excel file that needs to go into a custom Revit family. The Excel file did not come from Revit, so it isn’t formatted to go into Revit. When Revit exports a table the formatting of the headers is ##parameter##units## (or some variation of this). The Excel headers need to be formatted this way to be put into Revit. Does anyone have any ideas on how to go about this?

[Danos]

@frank.v.smith

Excel file that needs to go into a custom Revit family

I don’t know if i understand it correctly, but do you want an excel file to act like a schedule in Revit? Or do you want to transfer data from your excel file to certain elements?

@frank.v.smith

The Excel headers

With headers, do you mean the first row in you excel file, or do you mean header text?

[frank.v.smith]

Ideally, I’ll have one very large file that I can pick and choose parameters from, move those parameters into a smaller file, and put that file into a Revit family

[Danos]

Maybe this thread can help you out?

HELP! Set project parameters from Excel File

Hello, I’m having a hard time trying to set multiple project parameters from an excel spreadsheet. I was able to get one of the parameter to set from the excel spreadsheet but I don’t know how to push to the rest of my project parameter list. I created a get parameter and also created a list. I created a file path to excel and create a list and i wanted to return whats in the list and set to my project parameters. I just dont know how to use 2 list to sort and setparameterbyname. Attached is…

[salvatoredragotta]

@frank.v.smith

Essentially I have a script that creates an Excel file that needs to go into a custom Revit family.

Could you upload your dyn and post screenshots. Thanks.