Display full version of the post: data exported to excel

davey1973
22.02.2011, 17:40
i use autocad lt 2010 and am trying to lift some info off a drawing and export it to excel. the info lookd like a table but hasn't been created as a table. you seem to be able to do it quite easily using autocad (ie NOT LT) using the data command in the tools menu or eattext command, but i cant find a way to do it in LT, can anyone help

John Connor
22.02.2011, 18:22
You say the information looks like a table.  Could it just be plain text?
Could this information be copied then pasted into Excel?
 
For future consideration if you have the need to work with the same information in both AutoCAD LT and Excel.
 
http://www.cadig.com/products/?gclid=CK6HmqqnnKcCFYHb4AodEgqNdAJohn Connor2011-02-22 18:40:51

HAWDesigner
22.02.2011, 18:52
You're correct, [CMD]DATAEXTRACTION[/CMD] and [CMD]EATTEXT[/CMD] are not available in LT. Check out ExcelLink. It exports attributes to Excel and -
unlike EATTEXT - it can also link them bidirectionally
(Excel<-->ACADLT).
http://www.cadstudio.cz/excellink


davey1973
22.02.2011, 20:42
thanks for that, the information is in editable attribute blocks, so i cant copy and paste

i will have a look at the cadstudio package and see if it will do what i need it to, thanks very much for that info guys, very helpful