You can create a complete table on the fly by importing data from Microsoft Excel.
Follow these steps:
- Select the data in Excel and copy it to the Windows Clipboard. In AutoCAD, choose Home tab@@>Clipboard panel@@>Paste drop-down list@@>Paste Special.
- In the Paste Special dialog box, choose AutoCAD Entities and click OK.
- At the prompt, pick an insertion point.
AutoCAD inserts the table.
Tested in AutoCAD 2011 and Excel 2010.
Ellen Finkelstein is the author of the best-selling AutoCAD & AutoCAD LT Bible, which started with R14. Ellen has written extensively on AutoCAD, including articles for Autodesk’s website and features for AutoCAD’s Help system. Ellen’s first book was AutoCAD For Dummies Quick Reference.
Latest posts by Ellen Finkelstein (see all)
- Combine or subtract 2D shapes to create custom shapes - February 17, 2022
- Working with linetype scales - January 18, 2022
- Rename named objects–blocks, dimension styles, layers, and more - December 21, 2021
Instagram
LinkedIn
Facebook
yea, for some reason that also works perfectly if you just do it “windows way” (ctrl+c and ctrl+v)
Yeah, it also works the other way, (just cut and paste) so you can drop a portion of an Auto-Cad drawing(from the model space) into a cell in excel.
Obviously it needs to be quite a big cell, you then just have to format the image to get it to fit the cell nicely and voila.
If you then double click the image in the excel document, it opens in Autocad and you can edit it.
Nice!
You can also create a Table Style in AutoCAD. After inserting the Table, right click & select DATA LINKS to create a new one choose an EXCEL file. Uncheck Excel Formatting to have your own Table Style. If you want you can detach the link later.
I HAVE MANY MORE MISTAKE ON THAT TIME DIMENSION TO CREATE TABLE MISTAKES , ANY ONE SHORT CUT TO COPY OF DIMENSION TO TABLE