Excel to drawing

Last updated September 30, 2020 by Steel Extensions tekla.extensions-steel@trimble.com

Software version: 
Not version-specific
Environment: 
Not environment-specific

Excel to drawing

Contents

 

Purpose and description
System requirements
Installing Excel to drawing
Using Excel to drawing
Application properties
Known limitations of this version
 

Purpose and description

Use the Excel to drawing component to insert excel tables into drawings.

System requirements

Tekla Structures version: Not version specific

Environments: All

Installing Excel to drawing

To install the extension:

  1. Download the Excel to drawing installer package from Tekla Warehouse. For more information see Downloading an application from Tekla Warehouse.
  2. Install the file package.

Using Excel to drawing

To use the extension:

  1. Open a Tekla model.
  2. Open a drawing.
  3. Click the Applications & components button  in the side pane to open the Applications & components cataloguser interface for displaying or modifying information in categorized lists

    For example, profile catalog and shape catalog are catalogs.

    .
  4. Search for Excel to drawing and then double-click to open it. .
  5. The Excel to drawing dialog window will open.

  1. Insert the *.xls/*.xlsx file you want to add to the drawing using the Open button .
  2. Make desired modification and click Apply and OK.
  3. Click on the extension's icon from the Applications & components catalog.
  4. You will then be prompted to pick one point to choose the table's position point.

     10. After you pick the point, the table is inserted.


Application properties

  1. General properties

    Field Description Default
    Excel file Use to browse the file you want to add to the drawing. The location of the last loaded file.
    Scale factor (%) Use to scale the file you want to add to the drawing. 100
    Horizontal alignment Define the horizontal alignment of the table in reference of the position point.
    The options are:
    • Left;
    • Right.
    Left
    Vertical alignment Define the vertical alignment of the table in reference of the position point.
    The options are:
    • Above;
    • Below.
    Above
  1. Cell and text properties

    Font options

    Select the section corresponding to the extension version you want to use.

    Excel to drawing version: 1.5

    Field Description Default
    Font name Define the font name.
    The option are:
    • From Excel - use the same name as the one in the excel file;
    • Select - use to choose the desired font.
    From Excel
    Here you can click the select button () to define the desired font.
    This option is available only when you use Select option.
    Inactive
    Font size Define the font size.
    The option are:
    • From Excel - use the same size as the one in the excel file;
    • Select - use to choose the desired size.
    From Excel
    Here you define the desired font size.
    This option is available only when you use Select option.
    Inactive/3.00
    Font color Define the font color.
    The options are the same as Tekla color.
    Default - Black
    Font bold Define if the font is bold.
    The options are:
    • From Excel - use the same as the one in the excel file;
    • Yes;
    • No.
    From Excel
    Font Italic Define the font is italic.
    The options are:
    • From Excel - use the same as the one in the excel file;
    • Yes;
    • No.
    From Excel
    Font Underline Applies the underline type.
    The options are:
    • From Excel - use the underline from the excel file
    • Yes - underline all the text
    • No - remove all the text underline
    From Excel

    Excel to drawing version: 1.4, 1.3

    Field Description Default
    Font name Define the font name.
    The option are:
    • From Excel - use the same name as the one in the excel file;
    • Select - use to choose the desired font.
    From Excel
    Here you can click the select button () to define the desired font.
    This option is available only when you use Select option.
    Inactive
    Font size Define the font size.
    The option are:
    • From Excel - use the same size as the one in the excel file;
    • Select - use to choose the desired size.
    From Excel
    Here you define the desired font size.
    This option is available only when you use Select option.
    Inactive/3.00
    Font color Define the font color.
    The options are the same as Tekla color.
    Default - Black
    Font bold Define if the font is bold.
    The options are:
    • From Excel - use the same as the one in the excel file;
    • Yes;
    • No.
    From Excel
    Font Italic Define the font is italic.
    The options are:
    • From Excel - use the same as the one in the excel file;
    • Yes;
    • No.
    From Excel

    Cell options

    Field Description Default
    Show cell Define whether the cells is shown or not.
    The options are:
    • Yes;
    • No.
    Yes
    Cell color Define the cell color.
    The options are the same as Tekla color.
    Default - Black
    Show cell border Define the font is italic.
    The options are:
    • From Excel - use the same as the one in the excel file;
    • No.
    From Excel
    Cell border type Define the cells border type.
    The options are the same as Tekla line type appearance.
     
    Cell border color Define the cell border color.
    The options are the same as Tekla color.
    Default - Black

    Text alignment options

    Field Description Default
    Horizontal alignment Define the horizontal alignment of the table text.
    The options are:
    • From Excel;
    • Left;
    • Center;
    • Right.
    From Excel
    Vertical alignment Define the vertical alignment of the table text.
    The option are:
    • From Excel;
    • Top;
    • Middle;
    • Down.
    From Excel

Known limitations of this version

  • Microsoft Excel is required to be installed.
  • Using mixed font types and sizes in the same cell is not supported;
  • Word wrap is also not supported; if you want to show the entire text in the cell, you have to adjust the cell manually, save the file and in the drawing, modify the inserted table;
  • Sub-script and super-script not supported;
  • Rotated text in excel is not supported;
  • File path length is limited to 158 characters.

Quick feedback

The feedback you give here is not visible to other users. We use your comments to improve our content.
We use this to prevent automated spam submissions.
Content rating: 
No votes yet