exceljs_workbook_worksheet_creation_and_file_export.ts

1import * as ExcelJS from 'exceljs';
2
3async function runQuickstart() {
4  // Create a new workbook
5  const workbook = new ExcelJS.Workbook();
6  
7  // Set workbook properties
8  workbook.creator = 'Me';
9  workbook.lastModifiedBy = 'Her';
10  workbook.created = new Date(2018, 6, 19);
11  workbook.modified = new Date();
12  workbook.lastPrinted = new Date(2016, 9, 27);
13
14  // Add a worksheet
15  const worksheet = workbook.addWorksheet('My Sheet');
16
17  // Add column headers and define column keys and widths
18  worksheet.columns = [
19    { header: 'Id', key: 'id', width: 10 },
20    { header: 'Name', key: 'name', width: 32 },
21    { header: 'D.O.B.', key: 'dob', width: 15 }
22  ];
23
24  // Add rows by Key-Value pairs
25  worksheet.addRow({id: 1, name: 'John Doe', dob: new Date(1970, 1, 1)});
26  worksheet.addRow({id: 2, name: 'Jane Doe', dob: new Date(1965, 1, 7)});
27
28  // Add rows by Array
29  worksheet.addRow([3, 'Sam', new Date()]);
30
31  // Write to a file
32  await workbook.xlsx.writeFile('export.xlsx');
33  
34  console.log('File created successfully!');
35}
36
37runQuickstart().catch(err => console.error(err));