Cannot read special characters

[hungdev]

Hi. Thanks for your work.
I have a problem with special characters in csv file.
With cell value are: ość, chào cưng, số học ... it can not read, it shows os___, and ch�o c_ng,
Could you tell me how to keep original format.
Here is my file: https://drive.google.com/file/d/16hpgli5ZOzSsEob4_14Q2WDBDtFEFiJU/view?usp=sharing
and here is my code:
https://stackblitz.com/edit/react-excel-to-json-parser?file=ExcelReader.js

Thanks!

[hungdev]

@SheetJSDev can you check it for me?

[ViniciusFXavier]

Same problem here

• The characters ç and ã

[hungdev]

@ViniciusFXavier I dont have much time to solve this problem. So i changed to https://github.com/nzambello/react-csv-reader
If you want, you can try it =)))
But i still hope author keep continue to fix it. Because this lib is great 👍

[SheetJSDev]

Can't access the file @hungdev but most likely you're specifying a UTF-8 file without the BOM. Without the BOM, Excel defaults to the local codepage. To force UTF-8 treatment, pass the option codepage: 65001 to read or readFile

[Dshah-bb]

@SheetJSDev Can you please let me know what should be done in case of write to UTF-8 with BOM? Below is the sample of the code I am using
`this.workBookCreator.setReport(report);
this.workBookCreator.setTranslations(translations);
this.workBookCreator.setReportMetadata(reportMetadata);
this.workBookCreator.setColumnsToIncludeInReport(columnsToIncludeInReport);
this.workBookCreator.setTypeHints(typeHints);
this.workBookCreator.setCustomFields(customFields);

    let workbook: WorkBook = this.workBookCreator.getWorkbook(workBookName);

    return this.xlsxModule.write(workbook, {
        bookType: 'csv',
        type: "string"
    });`

When I try to open this file in Excel it is not considering UTF-8 and the special characters are broken