[Search tip detail and code files using keywords, tip number, author name, etc ]
 
Insert Spreadsheets into Tables
Tip# 3298 By Leonid Nemirovsky On 15-Nov-2009
3.2
Rated By 5 users
Categories : Link Table Data
Software type : AutoCAD 2010
Rename File To : No Files to download.
Spreadsheets and AutoCAD go hand in hand. Many of us use them for both our construction documents and our reports. Why not make sure they are tied together?

 Frequent tipster Leonid Nemirovsky (check out his Better Than Nothing AutoLISP site) sends us a tip for inserting an Excel spreadsheet into an AutoCAD table.

"Initiate the Table command by typing Table on the Command line or selecting Table from the ribbon, a pull-down menu, etc. Select the From a data link radio button in the Insert Table dialog box.

"Then click Launch the Data Link Manager. In the Data Link Manager window, select Create a new Excel Data Link, which will open a window asking you to name the new link.

"After you've entered a name in the empty field, click OK and browse to your Excel file. To browse to the file, click on the ellipsis (the icon with the three dots).

"Once you have found your data file and verified it is correct with the preview window, click OK.

"Then close the Data Link Manager dialog box by clicking OK again.

 "Click OK in the Insert Table dialog box, and you are done."

Notes from Cadalyst Tip Patrol: Spreadsheets and AutoCAD go hand in hand. Many of us use them for both our construction documents and our reports. Why not make sure they are tied together? That way, if the numbers are wrong, at least they are the same in the drawings as in the reports! Working with tables is much easier in Excel than it is in AutoCAD. This process also works in reverse, meaning that if you have a table in AutoCAD, you can send it to an Excel file. Select a table and right-click on it, then select the export option to create a CSV file from it. In the Data Link Manager, you can change the file type from EXL to CSV and create a link to the table you exported. The Data Extraction Tool is very useful too.

 

 

 

 

 

 

 

Average Rating:
3.2


User comments


Log In