Import Excel Text

Import Excel data as text.

Icon

Command

Shortcut Key

Toolbar

ReadExcel.a4s

Toolkit

General

This function allows you to import selected data from the first worksheet in an Excel spreadsheet, and add it to the drawing as text.

You can also import Excel data into the Table Editor.

Procedure

  1. The file browser displays.

  1. Select the file you want to import and click Open.

  2. The Import Settings display.

Field

 

Description

Column Start

The first column in the range to import.

Column End

The last column in the range to import.

Row Start

The first row in the range to import.

Row End

The last row in the range to import.

  1. Set the range of data to import, and then click OK.

  2. You are prompted to:

Indicate top left corner of imported Excel data

  1. Click on the top left corner of the text table.

  2. The Excel data is added to the drawing as text items.