Word,Excel的相關template套件小記

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

const JsExcelTemplate = require("js-excel-template/nodejs/nodejs").default;
const excelTemplate = JsExcelTemplate.fromFile("test.xlsx");

excelTemplate.set("name", "John");
excelTemplate.set("age", 123);
excelTemplate.set("now", new Date());
excelTemplate.set("isBoy", true);
excelTemplate.set("isGirl", false);

const students = [
  { name: "Tommy", age: 12 },
  { name: "Philips", age: 13 },
  { name: "Sara", age: 14 },
  { name: "中文測試", age: 14 }
];

for (let i = 1; i <= 5; i++) {
  if (i <= students.length) {
    excelTemplate.set(`name${i}`, students[i - 1].name);
    excelTemplate.set(`age${i}`, students[i - 1].age);
  } else {
    excelTemplate.set(`name${i}`, "");
    excelTemplate.set(`age${i}`, "");
  }
}
excelTemplate.set(
  "average",
  students.reduce((p, c) => p + c.age, 0) / students.length
);

excelTemplate.set("students", students);

// nodejs:
excelTemplate.saveAs("out.xlsx");