Importing project parameter to excel

[Mehrdad_Ghanizadeh2R6B5]

Hi I would like to know what the best approach is for importing project parameters or asset data into excel and then after modifying them we import them into revit. I have a long list of asset data which all of them have descriptions , also all of these parameters are related to rebar and when you click on any rebars in revit you should be able to see those asset data.  What can we do to professionally import and export between revit and excel ? 

Thank you

[jeremy_tammik]

I cannot say what is best, nor comment on how professional it is, but the Revit SDK provides several samples that do exactly what you are asking for. The FireRating sample implements round-trip export and import of modified data. So does the AdnRevitApiLabsXtra repo:

• https://github.com/jeremytammik/AdnRevitApiLabsXtra

You can also check out the numerous examples provides by The Building Coder:

• https://thebuildingcoder.typepad.com/blog/2012/09/exporting-parameter-data-to-excel.html

I enhanced FirRating to work in the cloud with a NoSQL database, in case you ewould like to go beyond to Excel:

• https://github.com/jeremytammik/FireRatingCloud

[Mehrdad_Ghanizadeh2R6B5]

Hi Jeremy 

Thank you for your supporting on this topic, I wanted to ask about the second link that you have shared about excel implementation, as it said I have to populate shared parameter in the model but firstly I should say we already have some shared parameter which all assigned to rebars but we have another asset data that I need to add to that rebar again and then I want to export all of them into excel, Let's discuss in this way, what is your suggestion ? 

[jeremy_tammik]

Yes. Many of the samples demonstrate and implement such workflows.