Export out/Read Schedule data generated from Revit.

[nik.mazreen]

Hi,

Need help. How do i read/export data in schedule created in Revit using C#?

thx in advance.

-Nik-

[leslief]

Nik,

It might help to download the Revit SDK and look at the sample code.  I haven't worked with it, but there is a sample in there called MaterialQuantities, and the description is "Outputs an analysis of the materials that make up walls, floors, and roofs, and displays the output in Excel." so that may be a good place to start, if I am understanding your question correctly. 

-Leslie

[Joe.Ye · Accepted solution]

Hi Nik,

Revit didn't expose the API to read data from the schedule in Revit 2013 and the previous versions.

In Revit 2013, schedule's data can be exported via ViewSchedule.Export() method.

Here is the signature of this method.

public void Export(
string folder,
string name,

ViewScheduleExportOptions options)

Via this method, all data can be exported to a txt file. This file can be opened in Excel, view it conveniently in Excel.

And you app can also access this txt file to get specific data.

______________________________________________________________

If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!