Author Topic: script from excel - profile  (Read 1452 times)

0 Members and 1 Guest are viewing this topic.

flopo

  • Guest
script from excel - profile
« on: December 10, 2009, 02:01:16 AM »
Hello everbody,
I have an old script, made with excel, that is not working properly. Is about drawing ground profile (for

gas pipe).The problem is that the author of the script is gone, and i need this script mofied.
What should be modified: this script insert a lot of blocks (that are in the drawing before running the

script) , and i don't need all this insertion. The script should only draw the profile (of the ground),

through those point with coordinates inseted in excel sheet (1) and the table below, without anythig else

- see the drawing+scr+excel attached. Also, excel file (unfortunately protected) should permit insertion

for about 50-100 points ( elevation + distance between consecutive points) -now is working only with

30 points.
My request may be a little strange, but any help is great! Maybe somebody has already something

similar.  :)
Thanks!

Lee Mac

  • Seagull
  • Posts: 12929
  • London, England
Re: script from excel - profile
« Reply #1 on: December 11, 2009, 10:28:14 PM »
Looking at your script, you would be better off creating a LISP routine to perform all the actions as listed in the script and then making a script to call the LISP routine.

That way, not only will the actions be performed 10x faster, but you can add error handlers and such to the LISP, and make the whole process more robust.

Lee

flopo

  • Guest
Re: script from excel - profile
« Reply #2 on: December 14, 2009, 12:39:23 AM »
For me, lisp is very very dufficult :P
Can be made a connection between that lisp and an excel file? Or how to insert point coordinates?
Thanks!