AutoCad lisp & Excel

Question

AutoCad lisp & Excel

ercegs (Mechanical)

(OP)

17 Jun 08 03:35

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 (Computer) · Answer 1 · 2008-06-17 04:01:01

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 (Mechanical) · Answer 2 · 2008-06-17 04:08:43

RE: AutoCad lisp & Excel

ercegs (Mechanical)

(OP)

17 Jun 08 04:08

I'll try that.

Thanks

ercegs (Mechanical) · Answer 3 · 2008-06-17 07:51:51

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

Exxit (Computer) · Answer 4 · 2008-06-17 08:14:41

Quote:
...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 (Mechanical) · Answer 5 · 2008-06-17 08:23:01

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 (Civil/Environmental) · Answer 6 · 2008-06-17 13:15:21

Some possible solutions in these threads:

thread555-102043: Plotting Lines from an Excel table in AutoCAD
thread555-114803: Using CAD and Excel together

loosestring (Civil/Environmental) · Answer 7 · 2008-06-24 13:57:51

Maybe this will help.
http://www.jefferypsanders.com/autolisp_IMPORTXYZ.html

Come Join Us!

Posting Guidelines

Jobs

AutoCad lisp & Excel