Exporting data fro RVT to Excel

[Anonymous]

Hi!

I have seen a lot posts in both this forum and @jeremytammik' blog, but I would like to export in excel just several properties such as: thickness, material, or other specific properties. Could you address to good link where I could get it please?

[jeremytammik]

Look at the Revit SDK sample FireRating. It is in VB:

.../SDK/Samples/FireRating

It is also included in the ADN Revit API Training Labs in both C# and VB, and also other Excel export samples, e.g., Lab4_2_ExportParametersToExcel:

https://github.com/jeremytammik/AdnRevitApiLabsXtra

Cheers,

Jeremy

[Anonymous]

Thanks @jeremytammik for answering, I know very well your example, but I'm looking a good method to create a filter. Eg: exporting just the floor selected and just the properties that I would like to export. 

[Anonymous]

@jeremytammik I have found a good example about what I mean, it is something like Ideate BIMLink. I'm starting from RevitLookup-Snoop Current Selection and I'm trying to merge with Lab4_2_ExportParametersToExcel, but I'm getting huge errors

[Revitalizer]

Hi,

if you just want to export some properties to Excel, without all the programming background, you better use Dynamo.

http://dynamobim.org/learn/

https://forum.dynamobim.com/

Revitalizer

[Anonymous]

thanks @Revitalizer for answering , I know Dynamo but I prefer to do that through API, it's more familiar for me!

[jeremytammik]

Keep it simple!

https://en.wikipedia.org/wiki/KISS_principle

There is no need for complexity.

The Building Coder includes lots of samples exporting parameter values.

I much prefer to avoid Excelt, though.

Use CSV or JSON instead, or go straight to a cloud database such as mongodb, as demonstrated by FireRatingCloud:

https://github.com/jeremytammik/FireRatingCloud

[Anonymous]

@jeremytammik for the KISS_principle, I have already read it on your webinar http://au.autodesk.com/au-online/classes-on-demand/class-catalog/2016/revit/sd20908#chapter=0

I did not know your ill with excel because you wrote a lot of article about that!

Sorry for my insistence but I prefer to have my data in excel without any database in the middle! My idea is to merge RevitLookup-Snoop Current Selection with Lab4_2_ExportParametersToExcel. I have also found something interested in https://github.com/jeremytammik/the_building_coder_samples.

But at the end I need your "kostbar" help for doing that!

[jeremytammik]

A basic foundation of .NET knowledge and the experience you can gather from working through the Revit API getting started material is enough to get you up and running with the ADN labs installed and tested in the Visual Studio debugging environment:

http://thebuildingcoder.typepad.com/blog/about-the-author.html#2

https://github.com/jeremytammik/AdnRevitApiLabsXtra

Next step is to adapt the functionality to your own needs.

I cannot do that for you. 

If you need more help than that, please contact the Autodesk consulting team:

https://www.autodesk.com/services-support/consulting/overview

Good luck and have fun!

Cheers,

Jeremy