export-to-excel-new

const { export_json_to_excel } = require("export-to-excel-new")
var data = [
  { index: 0, username: "张三", password: 333 },
  { index: 1, username: "李四", password: 444 }
]
const fieldName = [{ prop: "index", value: "索引" }, { prop: "username", value: "用户名" }, { prop: "password", value: "密码" }]
export_json_to_excel(fieldName, data, "用户列表");

注解

---

export_json_to_excel参数示意

1. fieldName：表示表格的表头：例如：[{ prop: "index", value: "索引" }, { prop: "username", value: "用户名" }, { prop: "password", value: "密码" }],value为表头值，prop为每一列的标识
2. data：是数据：例如：[ { index: 0, username: "张三", password: 333 }, { index: 1, username: "李四", password: 444 } ] 注意数据每一项的对象key要与fieldName数组每一项的prop值对应，便于归整每一列的值
3. 第三个参数为表格名称：xxx

---

可支持es6、common.js