AutoCad lisp & Excel

[ercegs]

Does anyone know how to write a lisp file that will use data from Excel to draw something.

I want to enter coordinates of points in Excel, and to create lisp file which will use these coordinates to draw lines, circles etc..

Thanks in advance.

 

[Exxit]

Hi ercegs,

why don't you use the script command?

http://thecadgeek.com/blog/2007/09/18/creating-script-files-with-excel/

Lothar

ADT 2004

 

[ercegs]

I'll try that.

Thanks

 

[ercegs]

No. This is not good for what I need. I must have LISP file which can take data from excel spreadsheet.

 

[Exxit]

...I must have LISP...

Why?

I am not familiar with lisp. But give us an example of your data. Is it like 3 point coords..?

ADT 2004

 

[ercegs]

For instance. I have four points (their coordinates) which makes one rectangle, and I'm going to have a couple of holes (circles) in it.

So, I want to enter vertex coordinates of rectangle and coordinates of holes in excel, and to make lisp to use it when I give him command "LINE" or "Circle".

For start, it would be great if I could just draw a simple rectangle using point coordinates from excel.

 

[CarlB]

Some possible solutions in these threads:

thread555-102043
thread555-114803

 

[loosestring]

Maybe this will help.

http://www.jefferypsanders.com/autolisp_IMPORTXYZ.html