1.引入js (dist目录下JsonExportExcel.min.js
)
<script src="https://cuikangjie.github.io/JsonExportExcel/dist/JsonExportExcel.min.js"></script>
或者npm安装
npm install -save js-export-excel
const ExportJsonExcel = require('js-export-excel')
2.js代码
var option={};
option.fileName = 'excel'
option.datas=[
{
//第一个sheet
sheetData:[{one:'一行一列',two:'一行二列'},{one:'二行一列',two:'二行二列'}],
sheetName:'sheet',
sheetFilter:['two','one'],
sheetHeader:['第一列','第二列']
},
{
//第二个sheet
sheetData:[{one:'一行一列',two:'一行二列'},{one:'二行一列',two:'二行二列'}]
}
];
var toExcel=new ExportJsonExcel(option);
toExcel.saveExcel();
option
datas 数据