There is an API sample that automates the process of getting panel schedule data from Revit into another application, such as Excel. The sample is quite rudimentary, as it is intended to provide developers just enough sample code for the base functionality to enable them to then create an export function tailored to specific requirements.
Below are the steps you may follow to try this functionality out. Some electrical design firms have staff with enough background to be able to massage the sample into something that would be quite useful. Hopefully, this helps get such folks on their way.
You will need some flavor of Microsoft Visual Studio to build the sample. You can download Microsoft Visual C# 2010 for free.
From the installation image or DVD for Revit, upzip the file \DVD\Utilities\SDK\RevitSDK2014.exe
In Visual C# 2010 Express:
- File > Open Project
- Browse to the folder \Software Development Kit\Samples\PanelSchedule\CS
- Select the file PanelSchedule.csproj
- Click Open
Make sure the Solution Explorer is visible
- View > Other Windows > Solution Explorer
- In the Solution Explorer, expand References
Depending on your flavor of Revit (from a Suite, or stand-alone MEP), you may see a yellow warning icon on RevitAPI and RevitAPIUI. If you don’t see the yellow warning icon, skip to step 21.
- Select RevitAPI and RevitAPIUI.
- Right click, and select Remove.
- If prompted that they will be removed, click OK.
- Right click on References, and click Add Reference…
- In the Add Reference window, select the Browse tab.
- Browse to the appropriate folder, depending on your installation
- From a Suite:
- C:\Program Files\Autodesk\Revit 2014
- Stand-alone MEP:
- C:\Program Files\Autodesk\Revit MEP 2014
- Scroll to RevitAPI.dll
- Click to select it.
- Scroll to RevitAPIUI.dll
- Hold the CTRL key, and click to add to the selection.
- Click OK.
- In the Solution Browser, select RevitAPI and RevitAPIUI.
- Right click, and select Properties
- In the Properties window, make sure Copy Local is set to False
Build the sample
- From the Debug menu, click Build Solution.
- If prompted with a Save of Read-Only File, click Overwrite.
- In the Save File As window, click Save to accept the default save location.
- Close Visual C# 2010 Express.
In Windows Explorer:
- Browse to the folder \Software Development Kit\Samples\PanelSchedule\CS
- Copy the file
to
- C:\ProgramData\Autodesk\Revit\Addins\2014
- Browse to the sub-folder \bin\Release
- Copy the files
- PanelSchedule.dll
- template.html
to
- C:\ProgramData\Autodesk\Revit\Addins\2014
Launch Revit
- Open a project (or create a new one)
- On the Add-Ins tab > External panel > External Tools
You should see three new commands:
- Panel Schedule Sample – Export Data
- Exports all panel schedules (as .csv or .html) to the folder where the PanelSchedule.dll exists.
- Panel Schedule Sample – View Instance Creation
- Creates the panel schedule using the default template for the panel currently selected in the model.
- Panel Schedule Sample – Sheet Instance Creation
- Places all panel schedules in the current sheet view.