Want to save as Excel 2013 format (xlsx)

Asp.Net Hein

Hello, I want to save the gridview to excel file. If I change the place of (.xlsx) to (.xls) , it is saved as 97-2003 excel format.

But now I change the (.xlsx).

It is saved as excel file.But I cannot reopen the excel file.

Can anybody help me in my problem?

Thanks a lot :-)

grvid.AllowPaging = false;

getgrid();

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=file-name.xlsx");

Response.ContentType = "application/vnd.xlsx";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

grvid.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

grvid.AllowPaging = true;

getgrid();

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kimberlee Lowe11y ago
Are you using the code from the "Export GridView and/or DataGrid control to Excel file" article?
I'm afraid I cannot reproduce your issue, I am able to generate an XLSX file with all the data and the formatting from the GridView control.
Unfortunately without reproducing your issue I cannot say where the problem occurs, can you upload your project here so that I may take a look at it?
Asp.Net Hein11y ago
Now the excel file is saved. But there is no data in excel file.
Thanks a lot for your help to me.
Kimberlee Lowe11y ago
Hi, add this:

protected void btnGridViewExport_Click(object sender, EventArgs e)
{
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

// The rest of the code ...

Does this solve your issue?
Asp.Net Hein11y ago
Now I face error in this line

using (var htmlStream = new MemoryStream(options.Encoding.GetBytes(sw.ToString())))
excel = ExcelFile.Load(htmlStream, options);

An exception of type 'System.Exception' occurred in GemBox.Spreadsheet.dll but was not handled in user code
Additional information: License not set. Call SpreadsheetInfo.SetLicense() method before using any other class from GemBox.Spreadsheet library. Free version serial key is: FREE-LIMITED-KEY

Can you help me again?

Thanks a lot :-)
Kimberlee Lowe11y ago
That is because you are actually not creating an XLS file in the first place.
You see this is a known trick in which you are saving a HTML content into a file with an XLS extension and some excel applications (like MS Excel) are able to detect the HTML content and open this file anyway. You can verify this yourself by opening that XLS file in for example Notepad.

Also I need to point out that in the newer versions of MS Excel you will get an unfriendly warning message that states that a file's content and extension are not the same.

Now unfortunately the same trick does not work for XLSX file and I'm afraid that in this case you will have to generate a real XLSX file. You can use Open XML SDK 2.5 for this and you will have to read and convert the HTML content into a corresponding XLSX content.

Also just in case you are interested, as an alternative you can take a look at this C# component for excel file's processing. It can actually do this conversion from HTML to both XLS and XLSX file with C# in a straightforward manner. Even more you have a direct API for exporting excel file to an ASP.NET client.
If interested you can find here a full demonstration sample on how to export a GridView to an Excel file.