TheSwamp

CAD Forums => CAD General => Topic started by: alanjt on August 20, 2020, 09:58:39 AM

Title: Excel OLE - Access data in linked OLE without source file
Post by: alanjt on August 20, 2020, 09:58:39 AM

I have a drawing with an excel OLE spreadsheet. I would like to access the data, but it will not open.
The OLE is linked instead of embedded and I do not have the source spreadsheet.

Is there any way to extract the data or convert the OLE to embedded?

Title: Re: Excel OLE - Access data in linked OLE without source file
Post by: cadtag on August 20, 2020, 03:02:47 PM

maybe print to PDF, the copy the text from the PDF??

Title: Re: Excel OLE - Access data in linked OLE without source file
Post by: alanjt on August 26, 2020, 02:25:38 PM

Quote from: cadtag on August 20, 2020, 03:02:47 PM

maybe print to PDF, the copy the text from the PDF??

Wasn't the most elegant method, but I was able to OCR the PDF and copy the text.
Thanks for the suggestion.

Still would be nice if there was a way to convert and OLE to be embedded, but I get why it wouldn't/shouldn't be possible.