Grid save to excel special characters

Aspose.Cells Product Family
1

Hi,

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

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/vnd.ms-excel”;
HttpContext.Current.Response.Charset = “”;
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Unicode;
HttpContext.Current.Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
HttpContext.Current.Response.AddHeader(“Content-Disposition”, “attachment; filename=” + filename + “.xls”);

But it does not work.

Thanks

Ivan
2

Hi,

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: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/upgrade-to-modern-aspose-cells-component.html

Thank you.