Code Red > AutoLISP (Vanilla / Visual)

How to generate an excel list with all block names from multiple drawings?

(1/1)

CAD_guru:
How to generate by a LISP routine an Excel list with all block names from multiple drawings? :idea:
As result:

colum              |        block name
------------------------------------
.dwg name       |        ..
                       |        ..
                       |        ..
.dwg name       |        ..
                       |        ..
                       |        ..

dexus:
You can start here, this might help:

Write to excel (csv): http://www.lee-mac.com/writecsv.html

Execute on multiple drawings: https://www.cad-notes.com/run-a-script-on-multiple-dwg-with-scriptpro/

BIGAL:
My approach I write direct to excel, open a excel file and fill in 1st dwg block details. When you open next dwg get last cell address and then fill in details, keep repeating.

The write to a csv may be easier the only difference is to use "A" not "W" when you open file this will append to an existing file.

I would look into accoreconsole to process a lot of dwg's else just a script open a dwg, run a lisp, then close.

Lee Mac:
Have you considered using DATAEXTRACTION for this task?

Navigation

[0] Message Index