ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening an Excel file in OWC10.AxSpreadSheet (https://www.excelbanter.com/excel-programming/340252-opening-excel-file-owc10-axspreadsheet.html)

santhosh.b

Opening an Excel file in OWC10.AxSpreadSheet
 
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.S heetExportActionEnum.
ssExportActionNone,OWC10.SheetExportFormat.ssExpor tHTML);

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

Opening an Excel file in OWC10.AxSpreadSheet
 
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'


All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com