1.2.3 • Published 4 months ago
export-to-excel-new v1.2.3
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参数示意
- fieldName:表示表格的表头:例如:{ prop: "index", value: "索引" }, { prop: "username", value: "用户名" }, { prop: "password", value: "密码" },value为表头值,prop为每一列的标识
- data:是数据:例如: { index: 0, username: "张三", password: 333 }, { index: 1, username: "李四", password: 444 } 注意数据每一项的对象key要与fieldName数组每一项的prop值对应,便于归整每一列的值
- 第三个参数为表格名称:xxx