Want to save as Excel 2013 format (xlsx)

Question

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();

Kimberlee Lowe · Answer

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?

Kimberlee Lowe · Answer

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.

Kimberlee Lowe · Answer

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 Hein · Answer

Now the excel file is saved. But there is no data in excel file. Thanks a lot for your help to me.

Asp.Net Hein · Answer

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 :-)