Nokia Lumia 920 Excel not open

Question

I created a responsive website in Asp.net using C#, and it functions flawlessly on both desktop and mobile devices. However, when I download Excel for the Nokia Lumia 920, it is downloaded but does not open on the phone. It displays errors such as Incorrect format.

I have used the below-mentioned code for downloading Excel :

Response.AddHeader("content-disposition", "attachment;filename=" + ExcelFileName + ".xlsx");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringBuilder build = new StringBuilder();
//buid contain data
Response.Output.Write(build.ToString());
Response.Flush();
Response.End();

What can be the solution?

Answer 1

The issue is with your code, not the phone, which is in perfect working order. Since you are delivering HTML and the response's response headers are set to xlsx, the format is actually improper and not what the phone expects. On desktop, this only functions because desktop Excel is able to display HTML tables as excel sheets, however AFAIK, Excel 2007, and newer versions notify the user that the data is in the wrong format.

The only solution is to create a real Excel file using an excel library. Use EPPlus as an example; it's straightforward and suitable for servers. 

Here is the example of exporting ADO.NET DataTable to an excel sheet and serving it to the client :

https://stackoverflow.com/a/9569827/351383