Grid save to excel special characters


I need to export to Excel special characters like french accent “&”

I used this part of code
public void writeResponse(string filename)
workbook.Save(filename + “.xls”, Aspose.Excel.SaveType.OpenInExcel, Aspose.Excel.FileFormatType.Excel97, HttpContext.Current.Response);

I added

HttpContext.Current.Response.ContentType = “application/”;
HttpContext.Current.Response.Charset = “”;
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Unicode;
HttpContext.Current.Response.AddHeader(“Content-Disposition”, “attachment; filename=” + filename + “.xls”);

But it does not work.




I think you are using older version of the component. Please try out latest version/fix (attached) of Aspose.Cells for .NET, it should work fine. If you still find the issue, kindly create a sample code with template file to post us here, we will check it soon.

And, please check the document how you can upgrade to latest Aspose.Cells version:

Thank you.