Import from Excel

Try before you buy!

Try before you buy

Most of the plugins in the ModPlus software are free! But, approximately 30% of the plugins are paid. However, these plugins are distributed on the principle "Try before you buy" - which means that you can use these plugins in almost their full functionality and buy them only if you want!

Import from Excel

2179 | (0) |

Attention! The plugin is purchased for the specified version of the Autodesk product!

To use the purchased license, use the Personal account of the ModPlus software installed on Your computer
Old price: 0.00 RUB
500.00 RUB

  • Author: 
    Pekshev Alexander
    Plugin allows you to insert a table from Excel into a Revit drafting view

    Forum

    About files with the extension .mpif

    The file with the .mpif extension is a special installation file of the ModPlus (ModPlus Install File).
    These files allow you to install and update all ModPlus components using the auto-update module in case you do not have access to the internet or modplus.org

     

    CALL OPTIONS

    • Revit ribbon

    ICON

    32x32px 16x16px

    DESCRIPTION

    Plugin supports the conversion of basic properties of cells (size, borders, color) and text (font, size, position, color). Plugin writes information about the imported table to the current project. Plugin 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

    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:

    3

    Download

    Files with the file extension .mpif is used to install or update components and plugins in case of lack of access to the internet! ModPlus is installed using the web installer
  • Comments

Pekshev Alexander

Pekshev Alexander

Contacts

I do not write programs to order

RUB
USD