• This forum is the machine-generated translation of www.cad3d.it/forum1 - the Italian design community. Several terms are not translated correctly.

exportation in excel

  • Thread starter Thread starter Andrix24
  • Start date Start date

Andrix24

Guest
Hello everyone,
This is my first post and I hope you can help me.
design electric schematics, use autocad 2021 , and from a few days I have been working on drawings a little "data" where the bom are not tables but texts and lines. I need to export them to excel but on the net I found little and nothing that could help me in a concrete way.
Some of you have had my own problem and if you, how did you solve it?
thanks to all .
for completeness of information I attach a typical dwg..... thank you
 

Attachments

I'm sorry to tell you, but I'm afraid you have to go with the old "coleman" method. .
 
this program I wrote it in the distant 2004, updated in 2006, published in this forum at the request of a user who had your same problem plus from misalignment of data in column.
It's in vba, so you must have installed it, you find it on the autodesk site.
the macro is <esportatabelle>The code can be consulted.
in the dialog box ignores the misalignment % and click on select.
the command starts excel, asks you to locate through a window the data area in the dwg, asks you the file name, creates the excel file.
in the selection exclude the heading line.
Good job</esportatabelle>
 

Attachments

Forum statistics

Threads
44,997
Messages
339,767
Members
4
Latest member
ibt

Members online

No members online now.
Back
Top