PDA

View Full Version : How to export a material takeoff to a Excel sheet



danielbezerra
2007-05-17, 05:57 PM
Hello, I am trying to integrate a budget software with the Revit. This software is based on a Access data base and, for the time being, is importing Revit's schedules (Material Takeoff) in txt format. But has too many things that I want to calculate before send this schedule to the software and they cannot be done on Revit's schedules because its limitations. So I have two ideas: first I thought about creating a API to export all quantities to a data base, but I think that will be necessary to create a command for each category of the drawing (one for the walls, other for the door, another for the floors, etc). My second idea is to export my present schedule to a excel sheet and make these calculus on it. But I tried and tried and I did not learn how to access the schedule’s values by API.

So please, can anyone help me to export a Material Takeoff to an Excel sheet? It cannot be done by use the command export schedule of the Revit because I want to do some classifications and filter some things by a visual basic software.

GuyR
2007-05-17, 08:38 PM
How about using the standard database tools in .NET to directly export the data to the access database?

Guy

Danny Polkinhorn
2007-05-21, 03:06 PM
Guy's correct. You should use the database connectors in .NET to push the information direct from Revit to your Access-based budget software. Your program can do the calculations as it's populating the database.