Json导出Excel
我们采用JsonToExcel方法,好用的插件一枚!
使用方法:引入js即可
附上大佬插件地址:https://github.com/cuikangjie/js-export-excel
<!--JsonToExcel-->
<script src="https://cuikangjie.github.io/JsonExportExcel/dist/JsonExportExcel.min.js"></script>
//Json导出Excel
function JsonToExcel(jsonData, fileName, sheetName, sheetHeader) {
var option = {};
option.fileName = fileName;
option.datas = [
{
sheetData: jsonData,
sheetName: sheetName,
sheetHeader: sheetHeader,
// sheetFilter:['userNam','age','color','date','url']//列过滤(只显示这几列)
}
];
var toExcel = new ExportJsonExcel(option);
toExcel.saveExcel();
}
<div class="col-sm-1">
<