Excel table Import

Tools
1

Hi all,

I’m trying to build a custom tool similar to DiRoots to import Excel tables into Revit. My requirements are:

  1. Multi-sheet compatible (Schedule or Legend).

  2. Clean BIM: No dummy families or “junk” parameters.

Appreciate the help!

2

An excel ex-/import for schedules or selectable elements, similiar to diroots, is included in pyrevit since 5.3.1

maybe that can be a starting point for you?

1 Like
3

What I mean is copying a table from an Excel file that is not related to the project parameters (simply the form and text for the presentation tables, for example).

4

Just what sort of fidelity do you want with the import from Excel? That will determine how you want to read the Excel file. Some readers just bring in cell values, other readers bring in more information about formatting. Your options are bringing in just the data and create your own formatting from there using your desired text styles. Or use the Excel formatting to create new text styles, fill patterns, etc to match Excel (higher degree of difficulty.)

After reading in the data, it is pretty simple to then create text, lines and filed regions. If you don’t want to use any of the numerous python libraries available for reading Excel, then you can always use Microsoft.Office.Interop.Excel. It is quite robust and will be available on any system with Excel installed. But it has a steeper learning curve than something like OpenXML - which is what Dynamo uses and what I’d start with.

Or a fast and dirty method is Excel to AutoCAD to Revit - Explode. :wink: