Read from an excel worksheet -- dotnet general

Kaustav
11/11/2006 5:39:01 AM

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

RobinS
11/11/2006 11:46:06 AM

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.
[quoted text, click to view]

dotnet general : Read from an excel worksheet