Export text to excel for a batch of dwg files

[shravan.troy]

I am looking for a autoLISP that will export text from autocad drawing batch (say 25 drawings) to excel in the following format.

I need rows with drg file name, text and the layer (in which the text is as shown) - below sample rows

Can some one please help me with this one ?

Drg file name    text from autocad        layer
ARCH1001        TYPICAL                      TEXT
ARCH1001        Window11                 Window_schedule
ARCH1002        CUT BACK                   TEXT
ARCH1002        Window21                 Window_schedule
ARCH1003          6                                WELD
ARCH1003        Window31                 Window_schedule
ARCH1003        Window32                  Window_schedule
ARCH1003        Window33                  Window_schedule
ARCH1003        Window34                  Window_schedule

[Ajilal.Vijayan]

Hi,

Welcome to Autodesk forum.

You can do this DATAEXTRACTION (DX) command

[shravan.troy]

From which version of autocad this dataextraction command works ?

[Ajilal.Vijayan · Accepted solution]

I dont know from which version of autocad it started.

But should work from 2008 series.

Also I am not sure whether this command exists in LT (If you are using LT)

Which version you have ?

[shravan.troy]

It works, thanks a lot

[Ajilal.Vijayan]

---

@shravan.troy wrote:

It works, thanks a lot

---

You're welcome

Glad I could help.