Function execute

test/testPerformance.js:89–137

(options)

}

function execute(options) {
  console.log(
    `Test Run ${options.workbook}, ${options.style}, ${options.str}, ${options.count}`
  );

  const wbOptions = {
    filename: testFilename,
    useStyles: options.style === 'styled',
    useSharedStrings: options.str === 'shared',
  };
  const wb =
    options.workbook === 'doc'
      ? new Workbook(wbOptions)
      : new WorkbookWriter(wbOptions);
  const ws = wb.addWorksheet('data');
  ws.columns = [
    {header: 'Col 1', key: 'key', width: 25},
    {header: 'Col 2', key: 'name', width: 32},
    {header: 'Col 3', key: 'age', width: 21},
    {header: 'Col 4', key: 'addr1', width: 18},
    {header: 'Col 5', key: 'addr2', width: 8},
    {header: 'Col 6', key: 'num1', width: 8},
    {header: 'Col 7', key: 'num2', width: 8},
    {
      header: 'Col 8',
      key: 'num3',
      width: 32,
      style: {font: fonts.comicSansUdB16},
    },
  ];
  for (let i = 0; i < options.count; i++) {
    ws.addRow({
      key: i,
      name: randomName(5),
      age: randomNum(100),
      addr1: randomName(16),
      addr2: randomName(10),
      num1: randomNum(10000),
      num2: randomNum(100000),
      num3: randomNum(1000000),
    }).commit();
  }
  if (options.workbook === 'doc') {
    console.log('Writing doc');
    return wb.xlsx.writeFile(testFilename, wbOptions);
  }
  console.log('Committing Writer');
  return wb.commit();
}

function runTest(options) {
  const stopwatch = new HrStopwatch();