xlsx file not opening with Excel 2013 / 2010

[Venkata Ramaiah Potla]

HI , I am trying to download  zip file which is having Excel1.xlsx file . When I extract zip file tried to open excel its giving error "Excel cannot open the file Excel1.xlsx because the file format or extension is not valid" . before downloading Zip file I am creating writing data to excel compressing .

same thing If I am creating file with extension ".xls" its opening without any error message .

REgards,

Venkat

[Prasanth M]

Hi Venkata,

Error Message- “file format or extension is not valid”:

If the file format is different than the extension then the MS Excel show the error “file format or extension is not valid”. Can you let me know whether you are generating the xlsx file using XlsIO with the Version property? Find the code snippet and online documentation link to change the workbook version using XlsIO.

Code Snippet to change the Workbook Version:

//Select the version to be saved

workbook.Version = ExcelVersion.Excel2007; //or

//workbook.Version = ExcelVersion.Excel2010;

 

//Save it as "Excel2007" format.

workbook.SaveAs("Sample.xlsx");

 

Online Documentation to change the Workbook Version:

http://help.syncfusion.com/ug/asp.net/xlsio/default.htm#!Documents/xlsx.htm

 

If still the issue is reproducing then share us the code snippet which reproduces the issue.

 

Thanks,
Prasanth

[Prashansha Chaurasia]

Hello, 

There are various ways to fix this error mentioned in the below article. Please visit the URL:

https://community.spiceworks.com/how_to/175204-solved-excel-files-won-t-open

I hope it will fix the issue.  

Best Regards,

Prashansha

[Ramya Sivakumar]

Hi,

Thanks for sharing this, we will take a look at it

Regards,

Ramya