Previous in Forum: Rotating-Heatsink   Next in Forum: Digital To Voice Translator.
Close
Close
Close
14 comments
Guru
United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member Engineering Fields - Petroleum Engineering - New Member Hobbies - Target Shooting - New Member

Join Date: Jan 2008
Location: Spring, Texas
Posts: 3403
Good Answers: 150

Autocad Text (Table) Export to Excel

07/14/2011 5:26 PM

Ok guys, I've gone the other direction (imported a table from excel into Autocad as an OLE object.) many times. But now I need to go the opposite direction. I have a table (a hydraulic schematic BOM in point of fact) in an Autocad drawing that is a whole bunch of individual bits of text that I need to export into Excel in order to build a spare parts list.

I really do not look forward to copying and pasting each individual line of text into it's appropriate cell in excel. Is there another way to skin this cat?

__________________
Who is John Galt?
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be Good Answers:

These comments received enough positive ratings to make them "good answers".
Guru
United States - Member - USA! Hobbies - Musician - Sound Man Engineering Fields - Mechanical Engineering - More than a Hobby Technical Fields - Technical Writing - New Member

Join Date: Oct 2008
Location: City of Roses.
Posts: 2056
Good Answers: 99
#1

Re: Autocad text (table) export to Excel

07/14/2011 6:41 PM

I have encountered that exact (Hydraulic BOM even) same issue, and have yet to find the answer... I have historically retyped it all into excel by hand, which as you know can be painstaking, and introduces more chances for Human error (which I already do plenty of). I'll eagerly await any further responses of someone who might have a ace up their sleeve so to speak.

Good question!

__________________
Don't believe everything you read on the Internet!
Register to Reply
2
Guru
United Kingdom - Member - Not a New Member Hobbies - Musician - New Member Hobbies - Fishing - New Member

Join Date: May 2006
Location: Reading, Berkshire, UK. Going under cover.
Posts: 9684
Good Answers: 467
#2

Re: Autocad text (table) export to Excel

07/14/2011 7:38 PM

1. At command prompt, type tableexport

2. Select the table

3. Save the resulting (.csv) file

4. Open with Excel

I got the above fom "Help". I've tested it (on AutoCAD 2005 only), and it works.

I also found it (once!) on a menu, but can't re-find it.

__________________
"Love justice, you who rule the world" - Dante Alighieri
Register to Reply Good Answer (Score 2)
Guru
United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member Engineering Fields - Petroleum Engineering - New Member Hobbies - Target Shooting - New Member

Join Date: Jan 2008
Location: Spring, Texas
Posts: 3403
Good Answers: 150
#3
In reply to #2

Re: Autocad text (table) export to Excel

07/15/2011 9:35 AM

Not a valid command in Autocad 2002. Also not a valid command in the most recent release of Draftsight (open source clone of Autocad). need to see if I can find someone with a more recent release of acad around here to try this with. Now just for clarification, this is not an OLE object. It is a bunch of plain autocad text entities in a grid of lines, there is no metadata or intelligence here.

edit:

ok, tried it with ACAD 2006 and just as i suspected, this only works with a "table object" whatever that might be. (OLE object I suspect.) plain text is rejected when selected.

I gave you a GA anyway though because if the table had been built using the newer functions it would have worked.

I'm going to try outputting it as a text DXF file and playing with it and see if I can massage it with a text editor into a CSV format file. I'll let you know how things go.

__________________
Who is John Galt?
Register to Reply
Guru
United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member Engineering Fields - Petroleum Engineering - New Member Hobbies - Target Shooting - New Member

Join Date: Jan 2008
Location: Spring, Texas
Posts: 3403
Good Answers: 150
#4
In reply to #3

Re: Autocad text (table) export to Excel

07/15/2011 10:28 AM

ok, while exporting it as an ascii dxf file then renaming it as a TXT file and opening it in a text editor to massage it technically works, the text is buried in a lot of formatting and is not in any sort of order so it is going to take a LOT of massaging to get anything usable. not to mention bits of text like the quantities which are single digit integers get lost in all of the formatting data and there is mo clear way of determining which one belongs to which item number or part number or description. so it looks like I'm back to cutting and pasting each line of text.

__________________
Who is John Galt?
Register to Reply
Guru
United Kingdom - Member - Not a New Member Hobbies - Musician - New Member Hobbies - Fishing - New Member

Join Date: May 2006
Location: Reading, Berkshire, UK. Going under cover.
Posts: 9684
Good Answers: 467
#5
In reply to #4

Re: Autocad text (table) export to Excel

07/15/2011 10:54 AM

Do you speak BASIC?

I had a similar problem; some colleagues were producing artwork for numeric labels (to be etched onto copper clad fg (PCB-type material). I found to my horror that they initially typed in 1000 numbers (for a production run), then every 3 months or so, they edit every number (just adding 1000 to each) for the next run. I wrote them a bit of VB (took about an hour from go) to save them the tedious, error-prone task.

Taking the DXF export, it's fairly easy to identify (and modify) the text entries. If you look up "DXF structure" you can work out how to identify the text entries. You can then export them in .csv format. Only works if all the cells have text in, and any irrelevant text can be easily identified and ignored. Best way would be to save just the table part of the drawing, so only the "useful" text is present.

Can't promise anything, but if you want me to give it a go, pm me your e-mail address and I'll contact you - either send you my source code, or you could send me your DXF and I'll see what I can do.

(Don't hold your breath - this w/end is a bit busy, so I don't know when I can get round to it).

P.S. Ta for the GA.

__________________
"Love justice, you who rule the world" - Dante Alighieri
Register to Reply
Guru
United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member Engineering Fields - Petroleum Engineering - New Member Hobbies - Target Shooting - New Member

Join Date: Jan 2008
Location: Spring, Texas
Posts: 3403
Good Answers: 150
#6
In reply to #5

Re: Autocad text (table) export to Excel

07/15/2011 11:49 AM

I haven't farted with Basic since Quickbasic 4.5, VB completely loses me, too much like C which I could never wrap my head around. But I'm about halfway done with the copy and paste at this point so I'm thinking it is not worth the effort, but thanks for the offer. from here on out we'll do it as an excel spreadsheet and import it and we won't have this problem...

__________________
Who is John Galt?
Register to Reply
Guru
United States - Member - USA! Hobbies - Musician - Sound Man Engineering Fields - Mechanical Engineering - More than a Hobby Technical Fields - Technical Writing - New Member

Join Date: Oct 2008
Location: City of Roses.
Posts: 2056
Good Answers: 99
#7
In reply to #6

Re: Autocad text (table) export to Excel

07/15/2011 1:09 PM

That's been my solution... start them in excel and import to Autocad.

__________________
Don't believe everything you read on the Internet!
Register to Reply
Guru
United Kingdom - Member - Not a New Member Hobbies - Musician - New Member Hobbies - Fishing - New Member

Join Date: May 2006
Location: Reading, Berkshire, UK. Going under cover.
Posts: 9684
Good Answers: 467
#9
In reply to #5

Re: Autocad text (table) export to Excel

07/16/2011 8:50 AM

A bit of clarification - my "bit of VB" took about an hour, but to tell the truth, it was not really from "go". I looked back at it to refresh my memory - it was based on some code I'd previously written to analyse DXF files.

__________________
"Love justice, you who rule the world" - Dante Alighieri
Register to Reply Off Topic (Score 5)
Power-User

Join Date: Sep 2009
Location: N38º3', W085º3'
Posts: 326
Good Answers: 19
#8

Re: Autocad Text (Table) Export to Excel

07/16/2011 8:39 AM

I am guessing the table is composed of text you manually typed into it and not extracted info from attributes of acad blocks.

If so, then what I would do is copy the text to the clipboard then paste into excel. Most likely there will be reformatting needed in excel. I do not know any other way.

__________________
There's a theory stating if anybody discovers exactly what the Universe is for & why it is here, it will instantly disappear & be replaced by something even more bizarre & inexplicable. There's another theory stating this has already happened.D Adams
Register to Reply
Participant

Join Date: Jul 2011
Posts: 4
#10

Re: Autocad Text (Table) Export to Excel

07/18/2011 3:12 AM

Hi Rorschach,

Do you really need Autocad for Hydraulic Schematics? Have you considered E3 from Zuken, it is an electrical, panel, harness, fluid and hydraulic schematic tool. All the options are interlinked.

It is an intelligent object orientated - easy to use tool, that will eliminate the problems you are having. The BOM can be directly exported (or imported from Excell in fact) into Excell, and will be accurate. The drawings can be updated anywhere in your schematic, and this is reflected in the BOM. One mouse click, if you change anything will re-compile your BOM. I am also using Autocad at my new employer, and I am shocked at how long BOMs take to create. I am spending days doing it. In E3 takes it takes seconds.

Have a look at E3 from Zuken, you will be pleasantly surprised.(I am pushing for the introduction of E3 here by the way)

Regards

Bedfordwheelnuts.

Register to Reply
Guru
Engineering Fields - Instrumentation Engineering - New Member

Join Date: Dec 2009
Location: San Antonio, TX USA
Posts: 844
Good Answers: 28
#11

Re: Autocad Text (Table) Export to Excel

07/18/2011 1:40 PM

I'm going to try this after lunch, but, why not PDF the DWG, then use Adobe OCR text recognition to grab it. Should paste right into Excel.

__________________
"Do not worry about your difficulties in Mathematics. I can assure you mine are still greater". - Albert Einstein
Register to Reply
Guru
United Kingdom - Member - Not a New Member Hobbies - Musician - New Member Hobbies - Fishing - New Member

Join Date: May 2006
Location: Reading, Berkshire, UK. Going under cover.
Posts: 9684
Good Answers: 467
#12
In reply to #11

Re: Autocad Text (Table) Export to Excel

07/18/2011 5:05 PM

Like the idea - tell us if it works.

GA pending .

__________________
"Love justice, you who rule the world" - Dante Alighieri
Register to Reply
Guru
United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member Engineering Fields - Petroleum Engineering - New Member Hobbies - Target Shooting - New Member

Join Date: Jan 2008
Location: Spring, Texas
Posts: 3403
Good Answers: 150
#13
In reply to #11

Re: Autocad Text (Table) Export to Excel

07/18/2011 5:13 PM

Well, my immediate need has been resolved but I can see this coming up again in the future as we deal with legacy data. I too am curious how this works out.

__________________
Who is John Galt?
Register to Reply
Participant

Join Date: Jul 2011
Posts: 4
#14

Re: Autocad Text (Table) Export to Excel

07/19/2011 3:08 AM

Hi All,

Legacy data can be handled in E3. E3 will import DXF's for your graphical drawing, and will import your Excell for the BOM. Once you have the BOM, you can put intelligence into your drawings.

Regards

Bedfordwheelnuts.

Register to Reply
Register to Reply 14 comments
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be Good Answers:

These comments received enough positive ratings to make them "good answers".
Copy to Clipboard

Users who posted comments:

bedfordwheelnuts (2); Geode Hunter (1); JohnDG (4); RDGRNR (1); Rorschach (4); RVZ717 (2)

Previous in Forum: Rotating-Heatsink   Next in Forum: Digital To Voice Translator.

Advertisement