AutoCAD 2010/2011/2012

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

AutoCad Linked To Excel

516 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,234
Registered: ‎09-16-2009
Message 2 of 6 (510 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 (505 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 (502 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,234
Registered: ‎09-16-2009
Message 5 of 6 (493 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: 483
Registered: ‎06-06-2010
Message 6 of 6 (483 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.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.