本文介绍了导出 csv 文件、JavaScript 时出现 UTF-8 编码问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用下面的函数在 JavaScript 中将数组导出到 csv 文件,但是在 Windows7 中使用 Microsoft Excel 2013 时,汉字变成了乱码.
I use the below function to export an array to a csv files in JavaScript, but the Chinese characters become messy code with Microsoft Excel 2013 in Windows7.
我用记事本打开导出的文件,但它显示得很好.
I open the exported file with a notepad but it displays finely.
function arrayToCSVConvertor(arrData, reportTitle) {
var CSV='';
arrData.forEach(function(infoArray, index){
var dataString = infoArray.join(",");
dataString= dataString.split('
').join(';');
CSV += dataString+ "
";
});
if (CSV == '') {
alert("Invalid data");
return;
}
//create a link and click, remove
var link = document.createElement("a");
link.id="lnkDwnldLnk";
//this part will append the anchor tag and remove it after automatic click
document.body.appendChild(link);
var csv = CSV;
var blob = new Blob([csv], { type: ' type: "text/csv;charset=UTF-8"' });//Here, I also tried charset=GBK , and it does not work either
var csvUrl = createObjectURL(blob);
var filename = reportTitle+'.csv';
if(navigator.msSaveBlob){//IE 10
return navigator.msSaveBlob(blob, filename);
}else{
$("#lnkDwnldLnk")
.attr({
'download': filename,
'href': csvUrl
});
$('#lnkDwnldLnk')[0].click();
document.body.removeChild(link);
}
}
推荐答案
在csv字符串开头添加BOM解决的问题:
Problem solved by adding BOM at the start of the csv string:
var csv = "ufeff"+CSV;
这篇关于导出 csv 文件、JavaScript 时出现 UTF-8 编码问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!