Create Tables
Create Tables – imports Microsoft Excel file with multiple spreadsheets as a selected view types (Legend or Drafting View)
Configuration window settings
Select the Excel file from your computer to import.
Available Sheets - all the Sheets that exist in the selected file.
Tick the checkboxes for the Spreadsheets that you want to link to the Revit project.
Choose an existing Drafting View, Legend View, or create a new Drafting View for each spreadsheet.
Existing View Name can be selected or a new View Name can be created here.
Select what Text and Line Styles you would like to use.
Use the same Text and Line Styles as in MS Excel File – Excel2R will create new text types with the same text fonts, sizes and styles as they are in the Excel file. Text type name will consist of “E2R”, text size, text font name, and text font style.
Excel2R will create line styles in the Revit project according to line weights that are used in the Excel file.
Use Text Font from Revit Project – a table from Excel will be created with text styles from the current Revit project.
Use Text and Line Styles from Revit Project – will open the Line and Text Style Mapping window to map Excel line and text styles to Revit line and text styles.
Import Cell Fill Colors from MS Excel - this setting will create Filled Regions for cells that have a fill color in the Excel file.
To import selected Excel spreadsheets with predefined configurations into Revit, click Draw Table.
The result can be found in the selected (or newly-created) views:
Notes
The tool will skip spreadsheets that begin with “@” symbol in the Excel file.
When importing cell fill colors, only these standard colors can be properly imported into Revit. If you're using other colors, they might look slightly different when imported to Revit.
Tooltip On/Off
Tooltip On - shows the spreadsheet name and the file location when the cursor is over the active view.
Tooltip Off – turns off the tooltip visibility.
Last updated