Opening an Excel file in OWC10.AxSpreadSheet

[santhosh.b]

Hi,
I am using OWC10.AxSpreadSheet in my windows application which I need to use
to create XLS files as well as open XLS files using the same control. I was
however able to create XLS file and store it in the localsystem using the
Export method.
axSpreadsheet2.Export("c:\\testexport.xls",OWC10.SheetExportActionEnum.
ssExportActionNone,OWC10.SheetExportFormat.ssExportHTML);

The challenge I am facing is to open an existing XLS file in the OWC10.
AxSpreadSheet. Can any one please help me with this.

Thanking you in advance,
Santhosh

 

[Paul Hasell]

Hi,

I'm using the OWC11 version but I think it's the same...you can't open XLS
files using the OWC. You'd need to save the original XLS file as an 'XML
Spreadsheet' and then load into the OWC using the XMLUrl property. This
property requires an appropriate 'protocol' at the start such as 'http:' or
'file:' otherwise you'll get an 'unknown error'