Forums >> Revit Building >> Technical Support >> Scheduling exporting to Mircosoft Excell is it possible

BSMITH82

active

Joined: Tue, Mar 27, 2007
6 Posts
No Rating

This user is offline

View Website

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

This user is offline

Mr Spot

site moderator|||

Joined: Mon, Jan 12, 2004
2889 Posts

Just a little trick - if you are good at excel...

We export to excel for schedules quite frequently as a lot of our clients require a schedule in A4 format rather than going into the A1 sheet set.

 To aid changes we create multiple tabs in an excel file, one is called Revit Export and another is called Door Schedule (or whatever).

We copy the exported schedule content into the revit export tab and the other tab is preformatted and linked to the revit export tab so all the information automatically updates in the correct format and saves us having to format the schedule each time we export.

 HTH.

-----------------------------------

Regards,

Chris.

Co-Founder | BIM Consultant | Software Designer  B. Arch)

Xrev Revit API Addins | Revit Rants

This user is offline

View Website

TomDorner

active

Joined: Sun, Apr 25, 2004
1207 Posts

You can take the Excel option one step further as well.  You can export out the schedule taking care to give it a name and location that is not going to change.  Then in Excel rather than a copy/paste operation, go to the Data menu and then to Import External Data.  Choose a data file type of .txt then select your exported schedule.  Go through answering a few questions about your import and your data will be placed into the Excel sheet.  After the import, yu will have a external data tool bar present.  The ! icon is a refresh button that will refresh the contents in the Excel sheet based on the file yu imported in.  This is where taking care to name and place you export file from Revit comes in.  As long as you over-write the .txt export file you will be able to refresh the data in Excel.  Then like Mr. Spot suggests, develop additional tabs in Excel to provide the formatting and sorting you desire.

If you want to kick it up a notch further, you can do a similar theory, but this time exporting via ODBC and then linking the ODBC file into a report writer like Crystal Reports or into a database like MS Access to produce the reports. 

-----------------------------------

Tom

www.reviteer.com   http://twitter.com/Reviteer

This user is offline

View Website

Summary schedule

0

Lookup Tables again

1

Railing Quantity

0

Retaining Curtain Wall Door Scheduling Data

5

Dimensions and Exporting

2