Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save samuraitruong/316b5a6b90c0b8a98e59a09658d7e6cc to your computer and use it in GitHub Desktop.
Save samuraitruong/316b5a6b90c0b8a98e59a09658d7e6cc to your computer and use it in GitHub Desktop.
var Excel = require("exceljs")
var data = {
headers: ["name", "address", "age", "dbo","passed", "score"],
data: [
{name: "Truong", score: 4, dob: new Date()},
{name: "Truong1", age: 3, dob: new Date(), passed: false},
{name: "Truong1", score: 2, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 2, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 3, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 4, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 5, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 5, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 2, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 2, address: "123 xxx",age: 13, dob: new Date(), passed: true},
{name: "Truong1", score: 1, address: "123 xxx",age: 13, dob: new Date(), passed: true}
]
}
var workbook = new Excel.Workbook();
workbook.xlsx.readFile("./template.xlsx")
.then(function() {
// use workbook
var sheet = workbook.getWorksheet(1);
var rowData = [];
data.data.forEach(item => {
var row = [];
data.headers.forEach(x => {
row.push(item[x]);
})
sheet.addRow(row);
})
workbook.xlsx.writeFile("./out1.xlsx")
.then(function() {
// done
});
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment