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

[CAD_guru]

How to generate by a LISP routine an Excel list with all block names from multiple drawings?
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?