XML Entities in worksheet's xml file not converting #815

New Issue

2017-09-20T14:03:30Z

Neroth commented

2017-09-20 14:03:30 +00:00

(Migrated from github.com)

Hi,

I get some utf8 encoding errors when I'm tring to get values.

I'm getting my xlsx file through node's http module in binary format (raw) and converting it to a buffer (new Buffer([String], "binary");).
Opening with XLSX.read([Buffer], {type: "buffer"}); and converting my worksheet as json with XLSX.utils.sheet_to_json([XLSXObject]);.
In my header I should have "N° Client" or "Civilité" but I get "N�Client" / "Civilit�".
When I look in the xlsx (extract xlsx > xl > worksheets > sheet1.xml) I see N°Client / Civilité

Did I do something wrong ?
Thanks for your support !

Hi, I get some utf8 encoding errors when I'm tring to get values. I'm getting my xlsx file through node's http module in binary format (raw) and converting it to a buffer (`new Buffer([String], "binary");`). Opening with `XLSX.read([Buffer], {type: "buffer"});` and converting my worksheet as json with `XLSX.utils.sheet_to_json([XLSXObject]);`. In my header I should have "N° Client" or "Civilité" but I get "N�Client" / "Civilit�". When I look in the xlsx (extract xlsx > xl > worksheets > sheet1.xml) I see N°Client / Civilité Did I do something wrong ? Thanks for your support !

Sign in to join this conversation.