我从这个答案和问题线索中得到了解决方案:https://stackoverflow.com/a/27975629/5228251 https://stackoverflow.com/a/27975629/5228251
UTF-8 示例:
fs.writeFile(someFilename, '\ufeff' + html, { encoding: 'utf8' }, function(err) {
/* The actual byte order mark written to the file is EF BB BF */
}
UTF-16 Little Endian 示例:
fs.writeFile(someFilename, '\ufeff' + html, { encoding: 'utf16le' }, function(err) {
/* The actual byte order mark written to the file is FF FE */
}
经过上面的答案和它的线程后,我修改了我的代码,如下所示:
- 将分隔符选项更改为
"\t"
代替","
- 前置
"\ufeff"
到 csv 字符串
- 更改了要使用的编码
"utf16le"
代替"utf8"
这是我更新的代码:
var json2csv = require('json2csv');
var fs = require('fs');
var fields = ['car', 'price', 'color'];
var myCars = [
{
"car": "Audi",
"price": "£40000",
"color": "blue"
}, {
"car": "BMW",
"price": "£35000",
"color": "black"
}, {
"car": "Porsche",
"price": "£60000",
"color": "green"
}
];
var csvStr = json2csv({ data: myCars, fields: fields, del: '\t' });
fs.writeFile('file.csv', '\ufeff' + csvStr, { encoding: 'utf16le' },function(err) {
if (err) throw err;
console.log('file saved');
});
希望这对其他人有帮助。