Access embedded excel sheet in Visio drawing using C#

[OlaLu]

Hello,

I'm developing a C# application that is accessing Visio via COM. The Visio
drawings contain embedded excel sheets that I need to read. I've been
searching the net for some tips on how get access to the embedded excel data
but I'm lost.

Does anyone have an idea on what to do?

Thanks for your attention!

 

[Al Edlund]

if the "embedded excel sheets" are oledb embedded it might be easiest to go
to the source file directly since the user is really looking at a link of
the data.
al

 

[OlaLu]

There is no external source file which has been linked, the excel sheet has
been inserted or created in Visio. Or am I missing something?
I assumed I would have to somehow start a new COM link by using some object
in the shape containing the excel file.

The Excel shape has
shape.Object.GetType().IsCOMObject = True
shape.Object.GetType().FullName = System.__ComObject
shape.Hyperlinks.Count = 0

/Ola

 

[Al Edlund]

what I was attempting to determine is how was the data inserted; is it a
bitmap, is it a metafile table, is it an oledb link, etc. Each of these has
different issues which may or may not allow you to edit the data. What is
the object type that you are trying to execute upon?
al