Lisp to extract extract particular block data to excel sheet

[dxstudios]

Hi Friends, 

           i have a task to extract the data of particular attributes called FMS_ID from the dwg file to excel sheet , 

i have attached the sample file in this thread.

i need these blocks attributes has to be extracted to excel sheet .

could some expert help me to complete this task by providing lisp.

Thanks in Advance.

 

sample1.dwg

[dxstudios]

could someone please look on this thread & help me 

[ronjonp]

Look into the ATTOUT command.

[Steven P]

It's not something I have done, but there are a lot of online examples out there and on this site which will let you build something up. Might need to make it up in parts such as selecting all the right blocks, extracting the data, create a spreadsheet

 

But.... 

 

Lee Mac has a routine called global attribute extractor which might do the job (always worth a visit, he has a lot of really good stuff) - I'll let you find it yourself from his excellent resource

[hosneyalaa]

ETABLE.DCL ETABLE.lsp

[dxstudios]

Thank you so much for looking on this post, i will check with the provided solutions 

Edited October 8, 2020 by dxstudios