Discussion forum

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Is there a way to import excell 2007 into acad 2006?i can cut and paste, but it brings the table as an object.

what i am trying to replicate is the way it used to work between excell 2003 and autocad 2004.  (the excell info came is as dtext cad text entities) 

I could more easily manipulate them because they were just cad text. And the text was formatted and aligned just like the spreadsheet.

 I really don't want a linked spreadsheet or an mtext version I have to explode and format manually.

Thanks
Chris-

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
cadamson Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22.Jun.2011 Location: United States Using: 2006-2010 Status: Offline Points: 3	Topic: How to import excell into acad 2006? Posted: 22.Jun.2011 at 17:08
	Is there a way to import excell 2007 into acad 2006? i can cut and paste, but it brings the table as an object. what i am trying to replicate is the way it used to work between excell 2003 and autocad 2004. (the excell info came is as dtext cad text entities) I could more easily manipulate them because they were just cad text. And the text was formatted and aligned just like the spreadsheet. I really don't want a linked spreadsheet or an mtext version I have to explode and format manually. Thanks Chris-

John Connor Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 01.Feb.2011 Location: United States Using: AutoCAD 2018 Status: Offline Points: 7175	Posted: 22.Jun.2011 at 18:26
	Can't do a Datalink in 2006 as that feature was introduced in 2008. You can either bring it in as an OLE object or use some third-party software to manipulate it. See: http://www.dotsoft.com/xl2cad.htm Edited by John Connor - 22.Jun.2011 at 18:27
	"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>>

cadamson Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22.Jun.2011 Location: United States Using: 2006-2010 Status: Offline Points: 3	Posted: 22.Jun.2011 at 20:32
	thanks, I was hoping to find a workaround or a FREE LISP that would bring in the spread sheet as formatted simple text. Chris

John Connor Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 01.Feb.2011 Location: United States Using: AutoCAD 2018 Status: Offline Points: 7175	Posted: 22.Jun.2011 at 23:50
	Yes, everyone wants something for nothing. Take a look at this...Point Manager. http://lee-mac.com/ptmanager.html
	"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>>

Vladimir Michl Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Moderator Group Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2151	Posted: 23.Jun.2011 at 09:56
	Simple copy-paste (Paste as AutoCAD entities) should work. In newer AutoCAD versions, it brings the table as a TABLE object (AutoCAD table, not OLE table) but you can Explode it to simple entities.
	Vladimir Michl (moderator) ARKANCE - https://arkance.world - Autodesk Platinum Partner

cadamson Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22.Jun.2011 Location: United States Using: 2006-2010 Status: Offline Points: 3	Posted: 23.Jun.2011 at 17:19
	thanks John is that LISP only for importing points? will it bring in text from excell as i have described. Hasta La Vista.....

John Connor Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 01.Feb.2011 Location: United States Using: AutoCAD 2018 Status: Offline Points: 7175	Posted: 23.Jun.2011 at 17:50
	Take a look at this discussion too re: Text from Excel into AutoCAD. http://forums.autodesk.com/t5/AutoCAD-2000-2000i-2002-Archive/Import-Excel-to-AutoCAD/td-p/939170
	"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>>

Discussion forum

?CAD discussions, advices, exchange of experience

How to import excell into acad 2006?

?
CAD discussions, advices, exchange of experience