Hello,
Our Japanese customers have an issue with SJIS character codes when processed by Aspose, being displayed as garbled and in a format that is not readable. On the other hand, CSV files with character code UTF-8 are displayed correctly. Please see the attached zip folder with examples.Detailed information.zip (66.1 KB)
Thanks for the sample files and screenshot.
You need to set proper encoding to display/render it correctly. See the sample code for your reference:
e.g.
Sample code:
TxtLoadOptions options = new TxtLoadOptions(LoadFormat.Csv);
options.Encoding = Encoding.GetEncoding("Shift_JIS");
Workbook workbook = new Workbook("g:\\test2\\sample_SJIS.csv", options);
workbook.Save("g:\\test2\\out1.pdf");
workbook.Save("g:\\test2\\out12.xlsx");
Hope, this helps a bit.
Good Evening,
Description: [Free Support Forum - aspose.com] [Aspose.Cells Product Family] F0136681 - SJIS displaying as garbled in CSV files
Thank you for replying back so soon. I will forward this to my colleague Medini and she will advise the customer.
Kind Regards,
Broderick
Broderick Stanley | IDBS Support | IDBS
[support@idbs.com](mailto:support@idbs.com style=) | +44 207 660 1460 (EU) +1 800 881 9953 (US) | https://www.idbs.com
Follow us on Twitter | YouTube | Read our blog
To see how IDBS use your data, visit the Privacy Policy
If we do not hear from you again within the next 7 days we will assume the issue is resolved.
You will be notified and the call will be closed automatically after a further 7 days. Remember to quote your case reference number: ref:_00Dw0CmX0._5004JitWrC:ref in any correspondence, as this will assist us in providing you with a quick response.