CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE
Over 1.096.000 registered users (EN+CZ). AutoCAD tips, Inventor tips, Revit tips. Try the new precise Engineering calculator and the updated Barcode generator. New AutoCAD 2026 commands and variables.
RSS channel - CAD tips RSS tips
RSS discussions

Discussion Discussion forum

?
CAD discussions, advices, exchange of experience

CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.
This is a peer-to-peer forum. The forum doesn't replace the official direct technical support provided by ARKANCE for its customers.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedHow to import excell into acad 2006?

 Post Reply Post Reply
Author
cadamson View Drop Down
Newbie
Newbie


Joined: 22.Jun.2011
Location: United States
Using: 2006-2010
Status: Offline
Points: 3
Direct Link To This Post 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-
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
Direct Link To This Post 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>>

Back to Top
cadamson View Drop Down
Newbie
Newbie


Joined: 22.Jun.2011
Location: United States
Using: 2006-2010
Status: Offline
Points: 3
Direct Link To This Post 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
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
Direct Link To This Post 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>>

Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2118
Direct Link To This Post 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
Back to Top
cadamson View Drop Down
Newbie
Newbie


Joined: 22.Jun.2011
Location: United States
Using: 2006-2010
Status: Offline
Points: 3
Direct Link To This Post 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.....
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
Direct Link To This Post 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>>

Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,084 seconds.