Does anyone know if it is possible to access the spreadsheet object that has been embedded into dgn? Can it be passed to Excel.Application somehow?
Thanks.
OleCellHeaderElement is the object that I am able to get to, but I don't see any way of getting data out of it.
Viktor_Kulik said:Modifying or reading embedded OLE
OLE is so 20th century. It's fragile (the link is a hard-wired path) and, as you've discovered, the APIs reveal nothing useful.
What's supposed to happen with an embedded object is that a double-click in the host app. (i.e. MicroStation) will pop the appropriate editor (in your case, Excel). But the programmatic equivalent is opaque.
Regards, Jon Summers LA Solutions
Definitely agree about 20th century... I guess the only way it may be possible to do any kind of automation would be to get the location/range of the object and then do a double click in that area while monitoring for a new excel or word app and then attempt to connect to that application using GetObject... I guess i'll pass on this.