I need help with Autolisp

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

 

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.

 

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.

 

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!