I need help with Autolisp

Discussion in 'AutoCAD' started by Tough Guy, Aug 9, 2006.

  1. Tough Guy

    Tough Guy Guest

    Hi,

    I am looking for an autolisp code that will alow me to transfer
    coordinates from microsoft excel into autocad to draw circles. Please
    advise me on what I should do or where I can get the code.

    thanks,
    Chris
     
    Tough Guy, Aug 9, 2006
    #1
    1. Advertisements

  2. Tough Guy

    Carl00711 Guest

    I am actually writing something along those lines right now. Your best
    bet is to save the spreadsheet as a .csv, so AutoCad can read it as a
    text file, then, using Lisp you can open the file and read it line by
    line, so if you have a line of X, Y & Z co-ords and a radius it becomes
    quite simple.
     
    Carl00711, Aug 9, 2006
    #2
    1. Advertisements

  3. Tough Guy

    Jiro Guest

    HiHo;
    I saw a lisp program in Cadalyst some time back.
    It would be at www.cadalyst.com in "get the code"
    section. The program I'm thinking about uses a
    spreadsheet to create the information for AutoCad.
    I think the author was Tony.
     
    Jiro, Aug 9, 2006
    #3
  4. Tough Guy

    Carl AK Guest

    You don't ned to use lisp for this. If you get data in an Excel column
    to be in the format of;

    x1,y1 radius

    by using a formula something like:

    =A1&","&B1&" "&C1

    then in Autocad use the command "multiple" & "circle", then copy &
    paste your column of circle data, all circles will be drawn.

    HTH!
     
    Carl AK, Aug 9, 2006
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.