AutoCAD 2010/2011/2012

Reply
Member
Walker140
Posts: 4
Registered: ‎01-07-2011
Message 1 of 6 (533 Views)

AutoCad Linked To Excel

533 Views, 5 Replies
09-13-2011 09:30 AM

Hello,

 

I have an excel sheet with GPS coordinates of elevation and distance. I want to produce a cross section drawing with these points. Is it possible to link the excel data into AutoCAD without having me draw the cross section myself.

Any input would be helpful.

Thanks

*Expert Elite*
Patchy
Posts: 6,301
Registered: ‎09-16-2009
Message 2 of 6 (527 Views)

Re: AutoCad Linked To Excel

09-13-2011 09:51 AM in reply to: Walker140

It can draw PROFILE, not CROSS SECTIONS (Cross section is perpendicular to Profile)

Save excel to text file then use 3dpoly command , copy and paste in the coordinates.

Member
Walker140
Posts: 4
Registered: ‎01-07-2011
Message 3 of 6 (522 Views)

Re: AutoCad Linked To Excel

09-13-2011 10:04 AM in reply to: Patchy

So is it possible to make a 2D sketch using X and Y coordinates, by linking it to excel.
Sorry I wasnt really clear with proper terminology.

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 4 of 6 (519 Views)

Re: AutoCad Linked To Excel

09-13-2011 10:06 AM in reply to: Walker140

There may be a lisp program that does what you are looking for.  Do a search in the lisp forum to see if it exists, this issue has come up before so maybe someone wrote a program for it.

*Expert Elite*
Patchy
Posts: 6,301
Registered: ‎09-16-2009
Message 5 of 6 (510 Views)

Re: AutoCad Linked To Excel

09-13-2011 10:32 AM in reply to: Walker140

Yes it is possible, use lisp from Lee Mac .His good stuff is here

http://lee-mac.com/ptmanager.html

Valued Mentor
TerryDotson
Posts: 504
Registered: ‎06-06-2010
Message 6 of 6 (500 Views)

Re: AutoCad Linked To Excel

09-13-2011 10:57 AM in reply to: Walker140

First consider that the data may be Lat/Long which (not being a planar system) will create a very distorted profile if not projected to a system such as state plane.

 

If you were to consider third party software, the low cost DotSoft MapWorks civil/survey add-on can take your lat/longs from the spreadsheet, project them to state plane, then allow you to automatically connect the points to form profiles/sections.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!