Hi Suresh,
This error occurs when there is mismatch
between the file format and its extension. This can be resolved by setting
workbook version set to the required version.
· To
save a workbook in Excel2003 format, set the workbook version to Excel97to2003 and
save the file with extension ‘.xls’ i.e. binary file format.
· To
save a workbook in Excel 2007/Excel2010/Excel2013 formats, set the workbook
version to Excel2007/Excel2010/Excel2013 respectively and save the file with
extension ‘.xlsx’ i.e. open xml file format.
The below code example illustrates the same.
|
string fileName = Server.MapPath("App_data/Sample.xls");
IWorkbook workbook = application.Workbooks.Open(fileName, ExcelOpenType.Automatic);
IWorksheet sheet = workbook.Worksheets[0];
workbook.Version = ExcelVersion.Excel2007;
workbook.SaveAs(this.TextBox1.Text + ".xlsx", ExcelSaveType.SaveAsXLS,
Response, ExcelDownloadType.PromptDialog, ExcelHttpContentType.Excel2007);
|
We have provided a sample as per your scenario
in the below link for your reference. Kindly try with this and let us know.
Sample Link:
http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample226675246.zip
Please let us know if you need any clarification.
Regards,
Ishwarya N
