Create Table
The Create Table command copies the print region of the selected Excel worksheet and creates a static schedule (Table) in Revit as either a schedule or drafting view.
In Revit:
- Navigate to the Naviate tab >> Naviate Core panel >> Create Table command.
- Naviate opens up the Create Table dialog:
- Use the
button to add a new Excel table
- Use the
button to delete an instance of an Excel table
button will update the selected instance of the Revit table to the original Excel file.
button will finish and close the dialogue
- To create a new instance of an Excel table Select the
button which will open the format dialogue
- Select the format type between a Revit Schedule or a Revit Drafting view
- for a Revit Schedule, the Create Table feature will convert the Excel table into the header of a Revit schedule text and cells. This will not convert any images from the Excel file
- for a Revit drafting view, the Create Table feature will convert the Excel table into a drafting view as lines, text, and filled regions. This will also bring any images into the drafting view that were in the Excel file.
- Use the
button to select the file location
- Use the dropdown to select the sheet from the Excel file
button will run the command to create the schedule via the inputs
button will cancel and close the dialogue
- If colors are used, a warning will notify you that the colors may not match due to the color theme difference between Excel and Revit
- Select Yes to continue or No to cancel
- If you select to create a Revit Schedule and the Excel file has images, a warning will notify you that images will not be imported into the Revit Schedule
- Select Yes to continue or No to cancel
- Once you select to continue either the Revit schedule or drafting view will be created and the view will open.
- Schedules and Drafting Views are associated to their excel files and can be updated to any changes that are made to the excel files using the Update button
Note: A 'Print Area' of the area in Excel must be created the the sheet that is being converted.