Author Topic: Lisp results based on external data  (Read 16790 times)

0 Members and 1 Guest are viewing this topic.

MGEE

  • Guest
Lisp results based on external data
« on: November 17, 2003, 08:55:37 AM »
I would like to generate a pline rectangle, extrude it, and attach 4 nodes or pipe nipples to one side at specific points (of course). And each L,W,& H would be pulled from an XL sheet. ??Shoot me or wound me?
If I could get to this point in understanding Lisp, I could automate a tremendous amount of my daily duties.
Thanks for any insight.
MGEE

Edited:
Also I've made a custom Menu with my personal buttons and saved it as custom_MG but I have to load it each time I start up Acad.How do you make it load automatically?
Thanks MGEE


7Edit: I renamed this topic.

ELOQUINTET

  • Guest
Lisp results based on external data
« Reply #1 on: November 17, 2003, 09:08:48 AM »
ummm as far as the second part of your question you may wanna read the recent loading custom menus topic. did you put the directory in autocads search path? if you don't know go to tools/options/files and add the folder where your menu is stored. see i'm learning guys  :lol:

dan

Mark

  • Custom Title
  • Seagull
  • Posts: 28753
Lisp results based on external data
« Reply #2 on: November 17, 2003, 09:09:19 AM »
In The Visual LISP Developers Bible 2003 Edition By David M. Stein there is a chapter (21) on working with Excel, with examples.

As far as the menu goes, perhaps you could upload your .mns file to the lilly pond for us to look at.

http://theswamp.org/lilly.pond/
TheSwamp.org  (serving the CAD community since 2003)

SMadsen

  • Guest
Lisp results based on external data
« Reply #3 on: November 17, 2003, 09:13:26 AM »
Oh dear .. you need to read from Excel? What weapon would you prefer??

You know, some ppl would cut in here and recommend that you use VBA for these kinds of tasks. I would too, but of course it is possible to do from AutoLISP.

What version of Acad are you running? Should we assume that Excel is open when doing yer thing or should it be opened by AutoCAD? Would you like the fullblown type library solution or an anonymous solution?

SMadsen

  • Guest
Lisp results based on external data
« Reply #4 on: November 17, 2003, 09:14:14 AM »
Ah yes, read Dave's Bible first. Excellent!

daron

  • Guest
Lisp results based on external data
« Reply #5 on: November 17, 2003, 09:47:54 AM »
Am I missing something, guys? I see no reference in the opening thread on using excel for anything.

SMadsen

  • Guest
Re: Lisp results based on external data
« Reply #6 on: November 17, 2003, 09:53:22 AM »
Quote from: MGEE
And each L,W,& H would be pulled from an XL sheet. ??


^ ? .. and it did say "external data" (now it does at least)

daron

  • Guest
Lisp results based on external data
« Reply #7 on: November 17, 2003, 10:07:19 AM »
You know? I read that 3 or 4 times and never saw it.

Mark

  • Custom Title
  • Seagull
  • Posts: 28753
Lisp results based on external data
« Reply #8 on: November 17, 2003, 10:10:47 AM »
Quote from: Daron
You know? I read that 3 or 4 times and never saw it.

It is Monday Daron, I can tell becuase of my CDATE question!
TheSwamp.org  (serving the CAD community since 2003)

daron

  • Guest
Lisp results based on external data
« Reply #9 on: November 17, 2003, 10:17:48 AM »
Okay! I'll go home now.

ELOQUINTET

  • Guest
Lisp results based on external data
« Reply #10 on: November 17, 2003, 10:20:37 AM »
daron probably looks very similar to ren right about now

dan

hendie

  • Guest
Lisp results based on external data
« Reply #11 on: November 17, 2003, 10:21:29 AM »
If I'm communicating externally from Acad with anything I go the VBA way. But like Stig mentioned, it is possible either way. I suppose it all depends upon how much programming knowledge you have and personal preference
Do you have any VBA or (V)Lisp experience ?

daron

  • Guest
Lisp results based on external data
« Reply #12 on: November 17, 2003, 10:39:22 AM »
Quote from: eloquintet
daron probably looks very similar to ren right about now

dan


minus the pink-eye.

MGEE

  • Guest
Lisp results based on external data
« Reply #13 on: November 17, 2003, 11:08:45 AM »
Don't have any VBA or VLisp knowledge.
On the other matter, I can & did build a custom menu but I have to load it myself every time I start ACAD.

Sorry I'm running Acad 2002

hendie

  • Guest
Lisp results based on external data
« Reply #14 on: November 17, 2003, 11:16:27 AM »
Is there any reason you are drawing a rectangle using a pline then extruding it as opposed to creating a 3d solid (box) ?