Tuesday, September 9, 2014

Practical Dynamo: Linking Revit with Excel

The BIM Troublemaker (great blog name!) has posted a step-by-step tutorial on establishing a bidirectional link between Revit and Excel using Dynamo.

In the example, the BIM Troublemaker targets specific family instances to write data out to Excel, and then targets a specific parameter in those same family instances to write data back in. In so doing, the BIM Troublemaker has shown us how to use the Dynamo graphical programming platform in a practical way to round trip targeted information between Revit and Excel.

The practical possibilities of this readily adaptable example are endless, and the subtlety of targeting specific elements and even specific parameters within those elements is oh so much more palatable than the sledgehammer-like application of some tools, such as Autodesk's own DBLink add-in.

Troublemaker indeed.

Revit out to Excel

Excel into Revit

BIM Troublemaker: Practical Dynamo - Excel Linking

"I think the day will come when, when delivering add-ins, instead of delivering executable programs, people will deliver [graphical programming platform] definitions." - Rob Snyder, Bentley Systems, circa 2008

Credit: Luke Johnson's What Revit Wants blog.

No comments: