Part becomes garbled after converted from xls to xlsx

Aspose.Cells Product Family
1

Hello, after this xls file is converted into xlsx file through aspose, the Chinese part becomes garbled. Please help me check the reason
杭职10.31-11.30日明细(2).XLS.zip (12.6 KB)

2

@wanghq09
By using sample files for testing, we can reproduce the issue. Discovered partial data benefits garbled after converted from xls to xlsx.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45743

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@wanghq09,

This is to notify you that your issue (logged as “CELLSJAVA-45743”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.12) that we plan to release in the next week. You will be notified when the new version is published.

4

@wanghq09
The xls file is very old Excel 4.0 file ,and there is no code page setting in the file, so we can not select correct encoding.
In the next version, we will get default encoding by region setting:

	LoadOptions options = new LoadOptions();
		options.setRegion(CountryCode.CHINA);
		Workbook wb = new Workbook(dir +"杭职10.31-11.30日明细(2).XLS", options);

It’s better that asking the user resaving the file as Excel 97-2003 or advanced version.

5

The issues you have found earlier (filed as CELLSJAVA-45743) have been fixed in Aspose.Cells for Java 23.12.