• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Visual LISP, AutoLISP and General Customization

    Reply
    Contributor
    Posts: 24
    Registered: ‎10-20-2008

    Excell to CAD Lisp Request

    255 Views, 3 Replies
    10-17-2012 09:44 PM

    Dear Lisp Developers,

    I need your help. I want to transfer some survey data from Excel to CAD. Please help, the requirement is as follows.

    we have survey datas in the form of excel. It has point numbers, Easting, Northing and Elevation. there are more than 100 points some times, now I want to locate this points to be inserted in AutoCAD at the proper Easting & Northing cordinates. when uploading to CAD I need a cross symbol with point number and elevations to be appeared in each points at the respective coordinates. I was using one excel sheet previously which is not working now. that also I'm attaching here for your reference. appreciate your help in need.

    Please use plain text.
    *Expert Elite*
    Posts: 842
    Registered: ‎08-16-2007

    Re: Excell to CAD Lisp Request

    10-18-2012 09:47 AM in reply to: kumaran123

    It looks like you have done a lot of development from the Excel end in sending AutoCAD your points using VBA.  Do you mean to abandon this approach?  If not, the VBA newsgroup might give more help.

     

    If so, consider saving excel data to a CSV format and having a LISP open the file and parse each line into points.  (Are you asking for hints or for a complete program?)

    Please use plain text.
    Contributor
    Posts: 24
    Registered: ‎10-20-2008

    Re: Excell to CAD Lisp Request

    10-19-2012 03:49 AM in reply to: dbroad

    Thanks for the replay, yes I need a lisp to make this convertion appreciate if you could have share it for me.

    Please use plain text.
    *Expert Elite*
    Posts: 842
    Registered: ‎08-16-2007

    Re: Excell to CAD Lisp Request

    10-19-2012 05:44 AM in reply to: kumaran123

    Sorry.  Although it can be done, I don't have one to share.  

    Please use plain text.