Drawing a table using content from a spreadsheet

Drawing a table using content from a spreadsheet

Tables can contain content from a linked .xls or .xlsx file, allowing you to easily share and update data between CAD drawings and external spreadsheets.

When you insert the table, specify the data link that references the content you want to include. The number and size of rows and columns of the new table are determined automatically based on the content in the spreadsheet.

For details about data links, Working with data links.

To draw a table that contains content from a spreadsheet

   1   Do one of the following to choose Table ():

    On the ribbon, choose Home > Table (in Annotation) or Annotate > Table (in Tables).

    On the menu, choose Draw > Table.

    Type table and then press Enter.

   2   In Table Style, choose a table style for the table. If necessary, click () to create or modify table styles.

   3   In Insert Options, select From Data Link.

   4   In the data link list, choose the data link that contains the content you want to include in the table. If necessary, select Open Data Link Manager () to create a data link or modify an existing one.

Data links are references to external files.
If you share your drawing with other uses, make sure you include any referenced .xls/.xlsx files.

   5   Click OK.

    6    In the drawing, follow the prompts to insert the table.