Import from Excel
- Revit ribbon
The main window of the function is divided into two parts. In the left part of the window, the list of imported Excel sheets in the current project is displayed. On the right side there are buttons for import management.
Each item in the list of imported worksheets contains the following information:
- Table – corresponds to the name of the drafting view on which the table is drawn
- Status – the status of the table. Possible values are: Ok, Table update required, The source file is missing, Source sheet is missing or renamed
- Source file - the name of the file from which the table was imported
- Source sheet - the name of the sheet that was drawn
Import control buttons
Add – opens a dialog box for adding a new table (see below)
Update – redraw the table selected in the list
Open view – Open the drafting view on which the table is drawn
Open source file – open the Excel file from which the table was imported
Delete – delete a drafting view on which the table selected in the list is drawn
When you refresh the table, a button Abort update appears, which allows you to abort a table update:
In the upper right part of the window there is a button that opens the settings window:
Thickness of lines – A list of line thickness ratios from Excel with Revit line weights. Valid values are from 1 to 16
Add new table
In this window you specify from which file and sheet in the file to import the table and in which drafting view to insert (draw) it. First of all, you need to select a file by clicking on the button with three dots. After you have selected the file, the list of sheets in the combo box below will be filled. Next you need to select the required sheet in the list of available worksheets. After you have selected the sheet, you must specify in which drafting view it should be drawn. You can create a new drafting view or specify an existing one.
Attention! When you import a table into an existing drafting view, all data in the view is deleted!
Information about the table is recorded in the extended data of the drafting view at the time of import. Next, you need to perform two actions:
Convert – starts the process of converting the selected sheet into intermediate data, through which the drawing will occur
Insert – creates a new drafting view (if necessary) and draws the imported table on it using Revit's annotation elements
Attention! Rotated text processing is only available in Revit 2019 and higher!
Tracking changes in real time
At the moment when the main window of the function is openly monitoring changes to the source file in real time. As soon as the source file is saved, in the main window of the function for all items in the list referring to the source file, the status: