Apose cells problems opening .cvs and .xls(x) with danish character set

Aspose.Cells Product Family
1

Hi Aspose

We are having trouble opening .cvs and .xls(x) workbooks that contains danish characters (Æ Ø Å).

These chars are replaced with “?” and other strange symbols both in cell content, listObject headers etc.

Can you please guide us on how to open these files and preserve the danish chars?

2

@bohoirup,

Could you please try to specify region while loading the XLSX file if it makes any difference:
e.g.
Sample code:

LoadOptions options = new LoadOptions();
options.Region = CountryCode.Denmark;
Workbook _document = new Workbook("e:\\test2\\Book1.xlsx", options); 
......

If you still find the issue, kindly zip and attach your sample file and paste your sample code (runnable) to reproduce the issue on our end, we will check it soon.