function JSONToCSVConvertor(JSONData, ReportTitle, ChineseTitle,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; if(arrData.length >= 20000) { alert("数据量过大无法导出,请把搜索时间范围缩短!"); return ; } if(arrData.length < 1) { alert("没有数据"); return ; } var CSV = ''; //Set Report title in first row or line CSV += ReportTitle + '\r\n\n'; //This condition will generate the Label/Header if (ShowLabel) { var row = ""; row = ChineseTitle; //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 + ','; //} 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]) { //添加'\t'为了防止科学计数 row += '"' +"\t" +arrData[i][index] +"\t" + '",'; } 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 = ""; //this will remove the blank-spaces from the title and replace it with an underscore fileName += ReportTitle.replace(/ /g,"_"); //Initialize file format you want csv or xls CSV = encodeURIComponent(CSV); var uri = 'data:text/xls;charset=utf-8,\ufeff' + CSV; //this trick will generate a temp 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 + "."; //this part will append the anchor tag and remove it after automatic click document.body.appendChild(link); link.click(); document.body.removeChild(link);};
上面是代码,一下是可以参考的文章:
http://blog.csdn.net/oscar999/article/details/16342699
http://www.oschina.net/project/tag/258/excel-tools
http://jsfiddle.net/hybrid13i/JXrwM/
http://my.oschina.net/zhaoyou/blog/9066