RevitDB: Edit your model in Excel

22 Mar

In an earlier post, I showed how to edit a Revit model from MS Access. In this post, I will show how to edit your model using Excel.

Here is the model.

The model is exported to an Access database using the RevitDB Link plugin. For more information on how this is done, see my earlier post. Once the database is created, import an Excel sheet and link it to an external sheet. In this example, I have a link called ‘WallsFromExcel’ to an external sheet called ‘Walls-Excel.’

When the ‘Walls-Excel’ spreadsheet is modified, it is automatically updated in the database because of the direct link.

Add a Query to the database that updates the Walls table from Revit with the spreadsheet. Run the query….

……and update the Revit model with DB Link.

Advertisements

2 Responses to “RevitDB: Edit your model in Excel”

Trackbacks/Pingbacks

  1. Revit REST API: Building as a Service | Architecture and Planning - January 21, 2015

    […] have written a few posts on Revit and Databases: Revit DB Link plugin, Modifying Revit Data through the Web and  Linking a Revit DB to a QR Code.  I also wrote a […]

  2. Revit REST API: Building as a Service « ExploreAbout.com - January 21, 2015

    […] have written a few posts on Revit and Databases: Revit DB Link plugin, Modifying Revit Data through the Web and  Linking a Revit DB to a QR Code.  I also wrote a […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: