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.
|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.