AutoCAD Express Tools

AutoCAD Express Tools

Reply
Member
axezen
Posts: 3
Registered: ‎04-09-2014
Message 1 of 7 (723 Views)
Accepted Solution

AutoCAD to Excel - Table made by line and text transfer

723 Views, 6 Replies
04-09-2014 07:50 AM

Hello,

 

I have a table but not not made by table command but line command. I would like to transfer the text of this hand made table content to excel. I tried "DATAEXTRACTION" but I could not manage to get anything from it. I need your help.

 

Thank you

 

PS: I attached the file.

You're very welcome.

I understand your inexperience with AutoCAD and its programming interfaces.

Please see the attached file - hopefully this will help you get over this little "speed bump".

In the ZIP file is:

1. A copy of the DWG you posted.

2. A DWG in which the 'table" from your DWG has been converted to an AutoCAD Table object.

3. A CSV (Comma Separated Values) file made by exporting the data from the AutoCAD Table.

 

The CSV file can be opened in Excel.  It will probably need some clean-up.

 

If you want to know more about how this was done (so that you might do it yourself), just ask and I will outline the process for you.

**Master
dmfrazier
Posts: 2,750
Registered: ‎05-13-2003
Message 2 of 7 (715 Views)

Re: AutoCAD to Excel - Table made by line and text transfer

04-09-2014 02:11 PM in reply to: axezen

Unfortunately there is no built-in command in AutoCAD that will do what you want.

See if this search result leads you to something that works:

http://forums.autodesk.com/t5/forums/searchpage/tab/message?filter=labels%2Clocation&location=catego...

 

Or this:

http://forums.autodesk.com/t5/forums/searchpage/tab/message?filter=labels&q=text+to+table

 

Member
axezen
Posts: 3
Registered: ‎04-09-2014
Message 3 of 7 (706 Views)

Re: AutoCAD to Excel - Table made by line and text transfer

04-10-2014 12:08 AM in reply to: axezen

Thank you Sir. From the links you've shared I understood that it is possible to do what I want by using list. I do not how to write or if I get a ready to work list, I do not know where to put the code in. I ve used some preprepared vba codes for excel but never i AutoCAD.

 

If you may forward me to someone who may help me, I will appriciate it.

 

Thank you.

Regards

*Expert Elite*
pendean
Posts: 22,494
Registered: ‎11-06-2003
Message 4 of 7 (699 Views)

Re: AutoCAD to Excel - Table made by line and text transfer

04-10-2014 06:22 AM in reply to: axezen
**Master
dmfrazier
Posts: 2,750
Registered: ‎05-13-2003
Message 5 of 7 (697 Views)

Re: AutoCAD to Excel - Table made by line and text transfer

04-10-2014 08:04 AM in reply to: axezen

You're very welcome.

I understand your inexperience with AutoCAD and its programming interfaces.

Please see the attached file - hopefully this will help you get over this little "speed bump".

In the ZIP file is:

1. A copy of the DWG you posted.

2. A DWG in which the 'table" from your DWG has been converted to an AutoCAD Table object.

3. A CSV (Comma Separated Values) file made by exporting the data from the AutoCAD Table.

 

The CSV file can be opened in Excel.  It will probably need some clean-up.

 

If you want to know more about how this was done (so that you might do it yourself), just ask and I will outline the process for you.

Member
axezen
Posts: 3
Registered: ‎04-09-2014
Message 6 of 7 (692 Views)

Re: AutoCAD to Excel - Table made by line and text transfer

04-10-2014 11:32 PM in reply to: dmfrazier

Thank you very much Sir.

I appreciate your help.

I definetely would like to do the process by myself next time, if you may give the directions.

Thank you again :smileyhappy:

**Master
dmfrazier
Posts: 2,750
Registered: ‎05-13-2003
Message 7 of 7 (644 Views)

Re: AutoCAD to Excel - Table made by line and text transfer

04-16-2014 02:04 PM in reply to: axezen

Sorry for the delay in getting back to you.

If I recall correctly, you can get an AutoLISP routine named "CONVERT OLD TABLE" (COT_Convert_Old_TableV1.6a.lsp) from here:

http://www.theswamp.org/index.php?topic=35884.0

 

Save a copy of the LISP file in one of your support folders.

(The following is based on AutoCAD 2013.)

Launch AutoCAD and load the LISP routine.  You can do this with AppLoad.

Once the LISP is loaded, run it with the COT command.  Just accept the defaults.  (I got an error at the end indicating a bad argument type, but it didn't seem to affect the results.)

The text and lines should now be a Table object.

 

Select the Table, right-click, and select "Export".

Change the "Files of type" to "Comma delimited (*.csv)", browse to a folder, and give the file a name.

 

Now you have a CSV file that you can open in Excel. 

 

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.