Convert an Excel Sheet Index into Revit Placeholder Sheets using Dynamo and Python.
Architects typically include a combined sheet index for all disciplines at the beginning of a drawing set. While Revit can easily create a list of sheets included in a model (and can also grab sheets from linked models), not all offices use Revit and not every transmission arrives with a model.
Rather than typing incoming sheet information line-by-line into a Revit schedule, Dynamo and Python can help convert Excel data into Revit Placeholder Sheets. Manual entry that could have taken hours (on a large project with hundreds of incoming drawing sheets) can now be completed in seconds.
Dynamo Definition: Excel Sheet Index to Revit Placeholder Sheets
This definition opens an Excel document, grabs values by column, replaces null values with “” to avoid a list mismatch, and feeds that data into a Python node.
Python Code: Excel Sheet Index to Revit Placeholder Sheets
Dynamo does not currently provide an OOTB node for Revit Placeholder Sheets so we will need to use Python code and the Revit API.
If you receive an updated sheet index, purge placeholder sheets in the model and re-import the new sheet index.
Dynamo Definition: Purge Existing Placeholder Sheets
This definition grabs all sheets in the model and feeds that data into a Python node.
Python Code: Purge Existing Placeholder Sheets
Similar to above, we will use Python and the Revit API to delete all Placeholder Sheets in the model. Non-placeholder sheets (visibile in the project browser) will remain.
The code above can be modified to include additional parameters based on your project and office standards. I plan to include phase information in my next iteration.
There's more information available on the andrewking(me) website.