AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

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

AutoCad Linked To Excel

547 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,322
Registered: ‎09-16-2009
Message 2 of 6 (541 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 (536 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 (533 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,322
Registered: ‎09-16-2009
Message 5 of 6 (524 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

Distinguished Mentor
TerryDotson
Posts: 514
Registered: ‎06-06-2010
Message 6 of 6 (514 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
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.