Read from an excel worksheet

[Kaustav]

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]

You have posted this message separately in the following
groups (that I know of):

microsoft.public.dotnet.framework.windowsforms
microsoft.public.dotnet.framework.interop
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.general

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.
"Kaustav" <Ka*****@discussions.microsoft.comwrote in message
news:2D**********************************@microsof t.com...

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.