导出 csv 文件、JavaScript 时出现 UTF-8 编码问题 [英] UTF-8 encoidng issue when exporting csv file , JavaScript

问题描述

我使用下面的函数在 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 编码问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！