topic Re: How to Export Data to Excel? in Revit API Forum

How to Export Data to Excel?

kasung3 — Sun, 13 Mar 2016 18:14:11 GMT

How to export revit data to a excel sheet and set formattings such as borders and underlines. Just like roombook, areabook and building book plugin. I want to create BOQs.

Re: How to Export Data to Excel?

jeremytammik — Sun, 13 Mar 2016 18:30:51 GMT

Dear Kasung3,

How to export data from Revit to Excel is demonstrated by the FireRating and other official Revit SDK samples.

How to set up borders etc. has nothing to do with Revit, so you will have to research that elsewhere.

This topic and associated areas were recently discussed by The Building Coder on RDBLink and Exporting Data from Revit:

http://thebuildingcoder.typepad.com/blog/2016/02/reorg-fomt-devcon-ted-qr-custom-exporter-quality.html#6

Best regards,

Jeremy

Re: How to Export Data to Excel?

kasung3 — Sun, 13 Mar 2016 19:49:57 GMT

Thank you for your reply.

In Roombook extension for revit export and set formattings nicely. How they have done it. Cannot we do it anyway

Re: How to Export Data to Excel?

jeremytammik — Sun, 13 Mar 2016 20:12:17 GMT

Yes, you can absolutely do the same.

Please refer to my answer above.

I do not care to repeat myself.

Best regards,

Jeremy

Re: How to Export Data to Excel?

Anonymous — Sat, 29 Feb 2020 12:17:15 GMT

Even I also found this task of exporting data to Excel too difficult but until i haven’t performed it. But after searching a lot for the fixes I have found that it’s not that tough to export data to Excel. You can also get benefit from this post.

http://www.repairmsexcel.com/blog/how-to-export-data-to-excel