test-table.js

const Excel = require('../lib/exceljs.nodejs.js');
const HrStopwatch = require('./utils/hr-stopwatch');

const [, , filename] = process.argv;

const wb = new Excel.Workbook();
const ws = wb.addWorksheet('Foo');

const now = new Date();
const today = Date.UTC(
  now.getUTCFullYear(),
  now.getUTCMonth(),
  now.getUTCDay()
);

ws.columns = [{key: 'date', width: 32}, {key: 'number'}, {key: 'word'}];

const words = [
  'Twas',
  'brillig',
  'and',
  'the',
  'slithy',
  'toves',
  'did',
  'gyre',
  'and',
  'gimble',
  'in',
  'the',
  'wabe',
];

ws.addTable({
  name: 'TestTable',
  ref: 'A1',
  headerRow: true,
  totalsRow: true,
  style: {
    theme: 'TableStyleDark3',
    showRowStripes: true,
  },
  columns: [
    {name: 'Date', totalsRowLabel: 'Totally', filterButton: true},
    {
      name: 'Id',
      totalsRowFunction: 'max',
      filterButton: true,
      totalsRowResult: 8,
    },
    {
      name: 'Word',
      filterButton: false,
      style: {font: {bold: true, name: 'Comic Sans MS'}},
    },
  ],
  rows: words.map((word, i) => [new Date(+today + (86400 * i)), i, word]),
});

const stopwatch = new HrStopwatch();
stopwatch.start();
wb.xlsx
  .writeFile(filename)
  .then(() => {
    const micros = stopwatch.microseconds;
    console.log('Done.');
    console.log('Time taken:', micros);
  })
  .catch(error => {
    console.log(error.message);
  });