OLE to Excel from AutoCAD

OLE to Excel from AutoCAD

jayhar
Advisor Advisor
7,211 Views
5 Replies
Message 1 of 6

OLE to Excel from AutoCAD

jayhar
Advisor
Advisor

Hi,

I have received an autocad file with excel file inserted on it. How can I extract to excel file from autocad OLE ?

Have any AutoLISP ??

Please Subscribe YouTube Channel
https://www.youtube.com/channel/UCclj8v9vHQiFa8_DriuAk3w

Please Mark the Post or Posts as Solution(s) to help others find the answer quickly.
0 Likes
7,212 Views
5 Replies
Replies (5)
Message 2 of 6

cadffm
Consultant
Consultant

The thread of the original file owner with the original file, is located here: LINK TO ANOTHER THREAD

curious..

 

@jayhar

There are no excel informations, only a stupid picture (if i am right), so you can only rebuild

this part of table by converter software what try to re-build from raster data 2 excel.

Competion one: Create a pdf in good quality of that table.

 

A good typist achieves the result faster and in perfect (excel) quality.
(PS: I would send it to India, where tasks are done quickly and cheaply)

Sebastian

0 Likes
Message 3 of 6

roland.r71
Collaborator
Collaborator

@cadffm wrote:

The thread of the original file owner with the original file, is located here: LINK TO ANOTHER THREAD

curious..

 

@jayhar

There are no excel informations, only a stupid picture (if i am right), so you can only rebuild

this part of table by converter software what try to re-build from raster data 2 excel.

Competion one: Create a pdf in good quality of that table.

 

A good typist achieves the result faster and in perfect (excel) quality.
(PS: I would send it to India, where tasks are done quickly and cheaply)


 

Indeed. Pretty awkward.

 

As for the OLE object: There's a difference between embedded & linked.

If the object is embedded, the objects is completely available within the dwg and can be edited. (separate from its source!)

If it's linked (as is the case here), the objects is only available as "grapical representation" and you need the original document to edit it.

 

Linked is used for 3 reasons:

1: it saves on the filesize, as the OLE object is not completely loaded into the dwg.

2: it allows for 1 source document to be edited and updates where linked.

3: without the source, the info can not be copied or edited (which prevents third parties from doing so !)

 

Trying to still export a linked OLE object, is like reverse engineering. (without the owners consent)

So, keeping point 3 in mind, sending it to india as pdf to have somebody recreate the excel...

that's like sending your iPhone to China and have it torn apart and build anew. I'm guessing Apple will not like you very much ... Smiley Wink

 

The only right way is to ask whomever created it if they could be so kind to share the source file.

Only if there is no source file available & you do have the rights to do so, having somebody recreating it becomes a (finall) option.

Message 4 of 6

Anonymous
Not applicable

1 Copy from Autocad, paste it on Microsoft Word

2 Now copy again from Word and now you can paste Autocad Entities with PASTESPEC on Autocad

3 Can use Table Export lisp to export table to an Excel spreadsheet

 

Want more?

Repeat 1 and convert the Word into PDF

2 Open it in adobe acrobat and export it to an Excel spreadsheet (also works with online converters such as IlovePDF)

3 This is the best option to keep the format

 

 

Message 5 of 6

lakshmikanthr22
Participant
Participant

This worked for me! Now stuck at running this lisp. How to run this lisp? what's the command? I opened a looked inside found "TE" but that didn't generate any csv or xls.

0 Likes
Message 6 of 6

tarslanZ6AC6
Community Visitor
Community Visitor

TABLEEEXPORT

0 Likes