4.23.2015

Layer Tips and Create Tables Linking To an Excel Spreadsheet

Layer Tips and Create Tables Linking To an Excel Spreadsheet

You can create a printable layer list from the new layer palette by selecting everything (CTRL+A), copying (CTRL+C) and then opening a new spreadsheet and pasting (CTRL+V).

layer-manager

Next tip: After pasting the data to spreadsheet. One easy way to do this is to copy the data from Excel. Select all of these items and then copy them to the Windows clipboard. Make sure the spreadsheet file is saved.  See Image 01 below.

spreadsheet
Image 01

Next, go back to AutoCAD. Then, in AutoCAD in the Clipboard panel on the Home ribbon tab, I'll select Paste Special. AutoCAD displays the Paste Special dialog. See image 02 below.
ribbon-tab
Image 02

In this dialog, I'll select Paste Link to paste the contents of the clipboard as a link. Notice that when I select Paste Link, I have a choice of pasting as a Microsoft Excel Worksheet or as AutoCAD Entities. Choose AutoCAD entities then Ok. See image 03 below.

paste-special-dialog-box
Image 03
As you hover the table there has an image look like a chain and padlock, these properties of the table have been linked and locked. To do this, click the cell; look up in the ribbon tab under “Table Cell” find the Cell Locking tab.  You will find the option of this, choose “Unlocked” and now you’re ready for editing.


autocad-table


Thanks for reading. Have a thoughts to share? Any comments are appreciated here. Next tutorial tips more on AutoCAD table editing and modifying.

The Future of Construction: Integrating Building Information Modeling (BIM) with AI Technology

The construction and architecture industries are poised for a technological revolution, driven by integrating Building Information Modeling ...