XLSX.js 导出Excel demo

GitHub：https://github.com/SheetJS/js-xlsx

一个js操作Excel的工具，如下代码，很方便的就将json数据导出为Excel文件。

使用示例：

//json 数据
var data = [{
        "a": 1,
        "x": 2,
        "b": 3,
        "y": 4,
                "success":true
    }, {
        "a": 1,
        "x": 2,
        "b": 3,
        "y": 4,
                "success":false
    }
];
//数据表格
var table=[];
table.push({
    A:"列A",
    B:"列B",
    C:"列C",
    D:"列D",
    E:"列E"
});
data.forEach(function (item) {
    var row={
        A:item.b,
        B:item.y,
        C:item.a,
        D:item.x,
        E:(item.success?'成功':'失败')
    };
    table.push(row);
});
//创建book
var wb = XLSX.utils.book_new();
//json转sheet
var ws = XLSX.utils.json_to_sheet(table, {header:["A","B","C","D","E"], skipHeader:true});
//设置列宽
ws['!cols']= [
    {width: 15},
    {width: 15},
    {width: 15},
    {width: 15},
    {width: 10}
];
var timestamp = (new Date()).getTime();
//sheet写入book
XLSX.utils.book_append_sheet(wb, ws, "file");
//输出
XLSX.writeFile(wb,"file"+timestamp+".xlsx");

 

转载于:https://www.cnblogs.com/huhangfei/p/11317056.html