Using Table Links
A TABLE object can be linked to data outside of AutoCAD if it is stored in a Microsoft Excel (XLS, XLSX, or CSV) file. The table can be linked to the entire spreadsheet, an individual row, a column, a cell, or a cell range in Excel.
This linked data can be linked to the AutoCAD table using the following three methods:
- As formulas with data formats attached
- As calculations from formulas calculated in Excel (with data formats not attached)
- As calculations from formulas calculated in Excel (with data formats attached)
A table that contains linked data will display “link indicators” around the linked cells. Information about the linked data can be viewed by “hovering” over the data link “indicators.”
Linking a Table to Excel
In this section, we will create a new table that reads block attributes from the active and referenced drawings and links an attribute value to an external Excel spreadsheet...