Reading from an excel worksheet

[Guest]

Hi,

I am facing a peculiar problem with Excel Automation. I have a winform where
in I display some data in OWC axSpreadsheet. Next I export this data to an
..xls file. When I try to open (through OleDb) and read this file, I get an
error -

"External table is not in the expected format." However, if I have the file
open in Excel, I am able to read it through code.

However the same piece of code works for some files without having them
opened in Excel. What am I missing out here? Please suggest.

 

[RobinS]

I saw this posting over in microsoft.public.dotnet.framework.interop.
When you post a message to multiple groups, please post all of them
at once. That way, if someone in one group provides a solution,
the solution will be posted to all of the groups. Also, if
someone in another group is working on a solution, they
will know it has been solved, and they can work on helping
somebody else.

Thanks,
Robin S.