INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Member Login

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?

Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Eng-Tips Posting Policies

Jobs from Indeed

jobs by

Link To This Forum!

Home > Forums > Engineering Computer Programs > General Engineering Programs > Autodesk: AutoCAD Forum

AutoCad lisp & Excel

Read More Threads Like This One

ercegs (Mechanical) (OP)

17 Jun 08 3: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)

17 Jun 08 4: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) (OP)

17 Jun 08 4:08

I'll try that.

Thanks

ercegs (Mechanical) (OP)

17 Jun 08 7:51

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

Exxit (Computer)

17 Jun 08 8:14

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) (OP)

17 Jun 08 8:23

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)

17 Jun 08 13:15

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)

24 Jun 08 13:57

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