Seek a lisp/python/vba for handle different lisp on specific path with csv format table or/and excel table

[skchui6159]

Can a lisp/python can handle a list of drawings (may be 1000 drawings) to do different action and load different lisps on a written excel table?

[hosneyalaa]

Please 

More details for your idea 

[paullimapa]

seems like doable function with lisp.

The overall lisp function would rely on Lee Mac's Read CSV lisp to convert the csv contents into lists.

Then create a script file that would open each dwg, run the command, load the lisp, run the function & save the dwg.

My suggestion to make opening & loading of the lisp function easier would be to save the path using either double back slashes "\\" for example:

C:\\Users\\user\\Desktop\\Sample\\Drawing2.dwg,"(command ""_.circle"" (list 5 0) 5)",C:\\Users\\user\\Desktop\\Sample\\AddCircle_A.lsp,(AddCircle_A),Y

or single forward slashes for example:

C:/Users/user/Desktop/Sample/Drawing2.dwg,"(command ""_.circle"" (list 5 0) 5)",C:/Users/user/Desktop/Sample/AddCircle_A.lsp,(AddCircle_A),Y

[Sea-Haven]

Depending on what you intend doing if it is as simple as making a circle, then you can get Excel to control the CAD and make objects. Using a VBA macro. I have a simple example makes a Line, Pline, circle.

You can use excel to make the script "G2" =CONCATENATE("open ",A2," ",B2," ","save Y") just copy column G to notepad and save as a script .scr file. Limited testing, may need file name in quotes if they have spaces in their names.

[skchui6159]

@Sea-Haven @paullimapa Thank you, great idea! I will try to write a vba export the copy reference of lisp and then write different condition of lisp. Finally, the wscript from Lee Mac to run the program!

[paullimapa]

glad to have helped...cheers!!!

[Sea-Haven]

Your script can have lisp in it, if its only a couple of lines of code do it that way, if lots of code look at the (load "myprogram") have last line matching the defun name to run.