excel-to-rvt

# Excel to RVT Import > **Note:** RVT is the file format. Examples may reference Autodesk® Revit® APIs. Autodesk and Revit are registered trademarks of Autodesk, Inc. ## Business Case ### Problem Statement External data (costs, specifications, classifications) lives in Excel but needs to update Revit: - Cost estimates need to link to model elements - Classification codes need assignment - Custom parameters need population - Manual entry is slow and error-prone ### Solution Automated import of Excel data into Revit using the DDC ImportExcelToRevit tool and Dynamo workflows. ### Business Value - **Automation** - Batch update thousands of parameters - **Accuracy** - Eliminate manual data entry errors - **Sync** - Keep external data in sync with model - **Flexibility** - Update any writable parameter ## Technical Implementation ### Methods 1. **ImportExcelToRevit CLI** - Direct command-line update 2. **Dynamo Script** - Visual programming approach 3. **Revit API** - Full programmatic control ### ImportExcelToRevit CLI ```bash ImportExcelToRevit.exe <model.rvt> <data.xlsx> [options] ``` | Option | Description | |--------|-------------| | `-sheet` | Excel sheet name | | `-idcol` | Element ID column | | `-mapping` | Parameter mapping file | ### Python Implementation ```python import subprocess import pandas as pd from pathlib import Path from typing import Dict, Any, List, Optional, Tuple from dataclasses import dataclass import json @dataclass class ImportResult: ...