Unable to read Japanese characters from CSV file

[dkommineni]

const XLSX = require('xlsx');

const workbook = XLSX.readFile('data.csv');
const worksheet = workbook.Sheets[workbook.SheetNames[0]];

const data = XLSX.utils.sheet_to_json(worksheet, {
raw: false, // Use raw values (true) or formatted strings (false)
header: ["Opp Name","Step Name","Opp Value"], // No header, all rows are data rows
blankrows: true, //Include blank lines in the output
});

console.dir(data)

==================

data.csv:

"Opp Name","Step Name","Opp Value"
"DE WM Domain Partner","Conditional Agreement","10002.1"
"DE SS Hybrid Cloud運用","Validated","12223.19"
"e-Dealer DR （Open系環境","Validated","233222.9"

[SheetJSDev]

Excel assumes CSV files are written in the local codepage (1252 in en-US). To force UTF8 interpretation, pass the option codepage: 65001:

const workbook = XLSX.readFile('data.csv', {codepage: 65001});

Alternatively, ensure that the tools generating your CSV files always insert the byte order mark \xef\xbb\xbf