Organic Posted July 9, 2012 Posted July 9, 2012 I have a table in Excel (well several tables actually) that I want to copy the contents from and insert into an AutoCad table. I don't want it as an OLE object (as I need to be able to edit it in AutoCad later if needed) and I don't want it as a datalink either, so what is the best way to do this? I was trying to just copy the cells although kept getting all cells ending up in each row/column. I believe it is possible somehow as I am sure I have done it multiple times before although can't work out how to do it now. Quote
mdbdesign Posted July 9, 2012 Posted July 9, 2012 Try attached lisp routines: First "Drawexcel" will draw simple lines and text based on excel file and than COT will convert this table to Autocad table. DrawExcel.dcl DrawExcel.lsp COT.lsp Quote
SLW210 Posted July 9, 2012 Posted July 9, 2012 I use Paste Special and select "AutoCAD Entities". Quote
mdbdesign Posted July 9, 2012 Posted July 9, 2012 I use Paste Special and select "AutoCAD Entities". Learn something new again. Thank you. Quote
BlackBox Posted July 9, 2012 Posted July 9, 2012 I use Paste Special and select "AutoCAD Entities". 1+ ... Been doing this since Land Desktop 2009 Quote
Organic Posted July 9, 2012 Author Posted July 9, 2012 I use Paste Special and select "AutoCAD Entities". Thankyou, this is exactly what I was looking for Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.