纯js EasyUI datagird 导出csv

这篇文章是借鉴别人博客写的，他的有转码问题，我的这篇解决了

原文网址：https://blog.csdn.net/current_person/article/details/50554884

js

function exportTable(){
var svl=$("#grid").datagrid('getData');//表格得值
var data= JSON.stringify(svl.rows);  
    JSONToCSVConvertor(data, true);
}
function JSONToCSVConvertor(JSONData, ShowLabel) {  
    //If JSONData is not an object then JSON.parse will parse the JSON string in an Object  
    var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData)  : JSONData;  


    var CSV = '';  


    //This condition will generate the Label/Header  

    if (ShowLabel) {  

 //This loop will extract the label from 1st index of on array  
        for ( var index in arrData[0]) {  
         //Now convert each value to string and comma-seprated  
            row += index + ',';  

        }  //自动遍历列

        //var row = "数量,型号规格,设备名称,设备类型,";  //手动写列
        row = row.slice(0, -1);  


        //append Label row with line break  
        CSV += row + '\r\n';  
    }  


    //1st loop is to extract each row  
    for (var i = 0; i < arrData.length; i++) {  
        var row = "";  


        //2nd loop will extract each column and convert it in string comma-seprated  
        for ( var index in arrData[i]) {  
            row += '"' + arrData[i][index] + '",';  
        }  


        row.slice(0, row.length - 1);  


        //add a line break after each row  
        CSV += row + '\r\n';  
    }  


    if (CSV == '') {  
        alert("Invalid data");  
        return;  
    }  
    //Generate a file name  
    var fileName = "设备统计信息";  


    //Initialize file format you want csv or xls  
    //var uri = 'data:text/csv;charset=utf-8,' + escape(CSV);  //乱码
    var uri = 'data:text/csv;charset=utf-8,\uFEFF' + encodeURI(CSV);//不乱码
    // Now the little tricky part.  
    // you can use either>> window.open(uri);  
    // but this will not work in some browsers  
    // or you will not get the correct file extension      


    //this trick will generate a temp <a /> tag  
    var link = document.createElement("a");  
    link.href = uri;  


    //set the visibility hidden so it will not effect on your web-layout  
    link.style = "visibility:hidden";  
    link.download = fileName + ".csv";  


    //this part will append the anchor tag and remove it after automatic click  
    document.body.appendChild(link);  
    link.click();  
    document.body.removeChild(link);  
}