Hello!

Did you know that logged in users can see a lot more content?

Excel to drawing

Last updated August 16, 2018 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

Excel to drawing component to insert excel tables into drawings for more information.

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

    1. Font options

      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
    1. 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
    1. 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 documentation.
We use this to prevent automated spam submissions.
Content rating: 
No votes yet