下面我就为大家分享一篇javascript将json格式数组下载为excel表格的方法,具有很好的参考价值,希望对大家有所帮助。
实例如下:
$(document).ready(function(){
$('#wwo').click(function(){
var data = {
"title":
[
{"value":"A1标题"},
{"value":"B1标题"}
],
"data":
[
[
{"value":"好好"},
{"value":"-08-24"}
],
[
{"value":"123"},
{"value":"hahah"}
]
]
};
if(data == ''){
return;
}else{
JSONToExcelConvertor(data.data, "Report", data.title);
}
});
});
function JSONToExcelConvertor(JSONData, FileName, ShowLabel) {
//先转化json
var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
var excel = '
//设置表头
var row = "
";
for (var i = 0, l = ShowLabel.length; i < l; i++) {
row += "
" + ShowLabel[i].value + '';
}
//换行
excel += row + "
";
//设置数据
for (var i = 0; i < arrData.length; i++) {
var row = "
";
for (var index in arrData[i]) {
var value = arrData[i][index].value === "." ? "" : arrData[i][index].value;
row += '
' + value + '';
}
excel += row + "
";
}
excel += "
";
var excelFile = "";
excelFile += '';
excelFile += '';
excelFile += "
";
excelFile += "";
excelFile += "";
excelFile += "
";
excelFile += excel;
excelFile += "";
excelFile += "";
var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);
var link = document.createElement("a");
link.href = uri;
link.style = "visibility:hidden";
link.download = FileName + ".xls";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
上面是我整理给大家的,希望今后会对大家有帮助。
相关文章: