将UTF-8 csv文件转换为Excel可读csv

Question

我用node.js生成一个utf-8编码的csv，然后在windows上双击打开它。Excel会启动，但某些特殊字符（如`、`、ü、ä、ö、ü...)无法正确显示。我想这是由于错误的编码。我保存了一个用Excel创建的新csv。我看到编码是Windows-1252。

data = helper.utf8_encode(data);
data = helper.utf8_decode(data);
data = windows1252.encode(data);
data = windows1252.decode(data);
data = helper.utf8_encode(windows1252.encode(data));
data = helper.utf8_encode(windows1252.decode(data));
data = helper.utf8_decode(windows1252.encode(data));
data = helper.utf8_decode(windows1252.decode(data));
data = windows1252.encode(helper.utf8_encode(data));
data = windows1252.decode(helper.utf8_encode(data));
data = windows1252.encode(helper.utf8_decode(data));
data = windows1252.decode(helper.utf8_decode(data));

\u0101 => Ä
\u010D => Ä
\u011D => Ä
\u0120 => Ä

\u0581 => Ö
\u058D => Ö
\u058F => Ö
\u0590 => Ö
\u059D => Ö
\u05A0 => Ö

\u0701 => Ü
\u070D => Ü
\u070F => Ü
\u0710 => Ü
\u071D => Ü
\u0720 => Ü

\u07C1 => ß
\u07CD => ß
\u07D0 => ß
\u07DD => ß
\u07E0 => ß

Answer 1

我对这个答案并不完全满意，因为使用npm install iconv命令会得到一个警告。不过，它应该能解决你的问题：

const Iconv = require('iconv').Iconv;
const fs = require('fs');
const iconv = new Iconv('utf8', 'utf16le');

let csvContent = 'ÉëÜè whatever you want';
fs.writeFileSync('test.csv', iconv.convert(csvContent));

• 原文来源:http://terminaln00b.ghost.io/excel-just-save-it-as-a-csv-nooooooo/
• 总结:https://davidburgos.blog/export-csv-with-correct-charset-in-nodejs/