I need help with Autolisp

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

  1. Tough Guy

    Tough Guy Guest


    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.

    Tough Guy, Aug 9, 2006
    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
    1. Advertisements

  3. Tough Guy

    Jiro Guest

    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
  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.

    Carl AK, Aug 9, 2006
    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.