Author Topic: embeded excel ole from side (external) database  (Read 2220 times)

0 Members and 1 Guest are viewing this topic.

nekitip

  • Guest
embeded excel ole from side (external) database
« on: October 15, 2014, 05:24:53 AM »
Has someone had a success in manipulating embeded OLE objects in side databases?
This is a side database:
http://spiderinnet1.typepad.com/blog/2013/03/autocad-net-read-dwg-into-memory-using-databasereaddwgfile.html


And this is how to open embeded excel objects:
http://forums.autodesk.com/t5/net/read-embedded-excel-sheet/td-p/3773610/page/2

But it appears that transaction cannot get OLE2FRAME object properly (half of its fields are empty) from side database. It feels like OLE object is not loaded at all.

nekitip

  • Guest
Re: embeded excel ole from side (external) database
« Reply #1 on: October 15, 2014, 07:45:54 AM »
so, after loosing 8h with exploring all of the amazing depths of undocumented world of autocad, here are some of the starting points for someone who stumbles to this problem:
sulution to open OLE objects was found on some (russian?) forum,
http://adn-cis.org/forum/index.php?topic=721.0
and by google translating it, the soution they have is to use
Code - C#: [Select]
  1. Database destDb = new Database ( false , false) ;
this has to do with:
http://adndevblog.typepad.com/autocad/2012/07/using-readdwgfile-with-net-attachxref-or-objectarx-acdbattachxref.html
however, you may find that now you have eNoInputFiler error
to solve this, you have to use document lock. But, since you do not have a document (you are, in fact, trying to open one!), you have to force the user to have at least one document
once he has one, any, you are able to do this:
http://adndevblog.typepad.com/autocad/2012/07/enoinputfiler-exception-when-using-readdwgfile.html
and then, open excel by combining
http://spiderinnet1.typepad.com/blog/2013/03/autocad-net-read-dwg-into-memory-using-databasereaddwgfile.html
and
http://forums.autodesk.com/t5/net/read-embedded-excel-sheet/td-p/3773610/page/2

This is the place where I will stop, and I have not tested this thoroughly. If anyone has something to contribute, please do.
Also, if someone writes this routine, it will be good for common routine thread.