Export to Excel does not respect Current Culture

Aspose.Cells Product Family
1

I am using aspose cells to export data from a grid to Excel and CSV. Everything works fine for US (en-us), but when I set my browser (and the app) to the UK (en-gb), it displays as US format in the excel export. The CSV displays correctly, but the Excel export does not.

Can anyone help?

I am using Aspose.Cell for .NET 4.4.1 in C# ASP.NET 2.0

2

Hi,

Thanks for considering Aspose.

I think you may try to set the following options e.g.,

Workbook workbook = new Workbook();

workbook.Language = CountryCode.UnitedKingdom;

workbook.Region = CountryCode.UnitedKingdom;

Thank you.