Excel data visualization and importing data from Excel file to the current Schedule
Icon
Related news and articles
Using
The main window of the plugin 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
Add – opens a dialog box for adding a new table (see below).
Update – redraw the table selected in the list.
Replace Source – replace the original Excel file and redraw the table.
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.
Remove link – delete the selected table from the list, but the drafting view on which the table is drawn remains (remove the link to the original Excel file).
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.
In the lower part of the window, you can choose one of the options for interaction with the drafting view after importing. The following actions are available: Ask, Open, or Do not open.
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.
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.
At the moment when the main window of the plugin is openly monitoring changes to the source file in real time. As soon as the changes to the source file are saved, in the main window of the plugin for all items in the list referring to the source file, the status:
English
