Table Linked to External Data

Integrating drawing data with external data files such as Excel spreadsheets

1. Start the Table command. Select From a Data Link (1) and click (2) to launch the Data Link Manager

2. In the Select a Link dialog box, select Create a New Excel Data Link and then enter a name for the new link

3. Browse to (1) and select the Excel document for the data link (2)

4. Choose to link to the entire sheet or to a range by specifying row and column numbers

5. Click OK to return to the Insert Table dialog box. Click OK in the Insert Table dialog box and click to place the table in your drawing

Importing Tables

Use the Windows® clipboard functionality and the Paste Special command of the software to import table data

Display properties such as fill colors and justification of the source table are maintained

The formulas and equations supported by the software are maintained

Exporting Tables

Export tables in a common format that you can process in other computers

When export a table from a drawing, it is stored in a CSV (Comma Separated Values) file

The CSV format is an universal format for tabular data and can be read by most spreadsheet

applications and other applications that are designed to manipulate tabular data

Style-related formatting, such as colors and text styles of the table, is lost because the CSV format is universal and is essentially an ASCII text file

All formulas are also removed, and only the resulting values for each formula are exported

Data Extraction Table Update

To update a table created from block attributes, need to perform a manual update

Select the table - Right-click - Update Table Data Links

Extract Attributes to Table

Data Extraction
Create schedules and tables by extracting data from blocks

1. Create a new Extraction

2. Data Source Definition

3. Object Selection

4. Select Properties

5. Data Refinement

6. Output Specification

7.Table Title and Style Selection

8. Data Extraction Templates

Block in Table

Include blocks within table cells

1. Formatting toolbar - Insert Block

2. Select the appropriate block

Adjust the properties

Field in Table

1. Formatting toolbar - Insert Field

Select the appropriate Field category

Select the Field in the Field Names list

Select the appropriate field property and formatting options