Create Tables – imports multiple selected MS Excel spreadsheets with predefined configuration into chosen View Type for each of them separately: existing drafting view, legend view, or new drafting view.
1. Browse MS Excel file from your computer or server.
2. Available sheets:
- Pick needed Spreadsheets that you want to link to the Revit project.
- Choose an existing drafting View, legend view, or create a new drafting view for
- Existing view Name can be selected or a new name can be created, if this option was selected previously.
3. 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 MS Excel. Text type name will consist of “E2R”, text size, text font name and text font style.
Excel2R will assign line styles from the Revit project according to line weights that are used in the MS Excel file.
*NOTE: Create and format the table in Excel to look like you want it to appear in Revit. Formatting should include fonts, character formatting such as bold, border lines with their desired line weights, cell sizes and justifications, and merged cells as needed.
- Use Text Font from Revit Project – Table from MS Excel will be created with Text Font from the current Revit® Project.
- Use Text and Line Styles from Revit Project –
|Line and Text Style Mapping – settings to map line and text styles.|
4. Tick to import Cell Fill Colors from MS Excel.
Draw Table – will import selected MS Excel spreadsheets with predefined configurations into chosen View Types.
The tool will skip spreadsheets that begin with “@” symbol in MS Excel.
Result can be found in drafting view, legend view, or new drafting view in the current Revit project:
NOTE: Only these cell colours fill in excel can be properly imported into Revit: