Print Page | Close Window

How to import excell into acad 2006?

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=6122
Printed Date: 17.Apr.2026 at 08:58


Topic: How to import excell into acad 2006?
Posted By: cadamson
Subject: How to import excell into acad 2006?
Date 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-


Replies:
Posted By: John Connor
Date 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


-------------
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>

Posted By: cadamson
Date 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

Posted By: John Connor
Date 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>>

Posted By: Vladimir Michl
Date 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" rel="nofollow - https://arkance.world - Autodesk Platinum Partner

Posted By: cadamson
Date 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.....

Posted By: John Connor
Date 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>>


Print Page | Close Window