how to read xls data as utf8

Question

User-1634604574 posted

i have this code to read xls file i want to read that file as utf8 how can i do it?

var workbook = XLSX.read(data, {
type: 'binary',

});

Answer 1

User-2054057000 posted

i have this code to read xls file i want to read that file as utf8 how can i do it?

var workbook = XLSX.read(data, {
type: 'binary',

});

Consider taking a look to this tutorial on Reading Excel file.

Answer 2

User839733648 posted

Hi [e-mail],

i have this code to read xls file i want to read that file as utf8 how can i do it?

var workbook = XLSX.read(data, {
type: 'binary',

});

According to your description and code, it seems that you are using SheetJS js-xlsx, right?

I've checked the official documentation and find that you may set the type as string.

string: JS string (characters interpreted as UTF8)

XLSX.read(data, {
  type: 'string',
});

For more, you could refer to : https://docs.sheetjs.com/#parsing-options

Best Regards,

Jenifer