Import from Excel

Import from Excel

Function allows you to insert a table from Excel into a Revit drafting view

To the store Forum Video


CALL OPTIONS

  • Revit ribbon

ICON

32x32px 16x16px

DESCRIPTION

Function supports the conversion of basic properties of cells (size, borders, color) and text (font, size, position, color). Function writes information about the imported table to the current project. Function allows you to monitor the changed source data in real time

USING

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.

1

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:

4

In the upper right part of the window there is a button that opens the settings window:

5

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

2

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

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:

3