test-protection-spinCount.js

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

const [, , filename, password] = process.argv;

const wb = new Excel.Workbook();
const ws = wb.addWorksheet('Foo');
ws.getCell('A1').value = 'Bar';

async function save() {
  const stopwatch = new HrStopwatch();

  stopwatch.start();
  await ws.protect(password); // default 100000
  console.log('Protection Time [spinCount default]:', stopwatch.microseconds);

  await wb.xlsx.writeFile(`${0}-${filename}`);

  // options defined but spinCount not
  stopwatch.start();
  await ws.protect(password, {insertRows: true}); // default 100000
  console.log('Protection Time [spinCount default]:', stopwatch.microseconds);

  await wb.xlsx.writeFile(`${1}-${filename}`);

  const values = [
    100000,
    10000,
    1,
    0,
    -1,
    undefined,
    null,
    NaN,
    Infinity,
    -Infinity,
    31415.9265,
  ];

  /*eslint-disable no-await-in-loop*/
  for (let index = 0; index < values.length; index += 1) {
    const value = values[index];

    stopwatch.start();
    await ws.protect(password, {spinCount: value});
    console.log(
      `Protection Time [spinCount ${value}]:`,
      stopwatch.microseconds
    );

    await wb.xlsx.writeFile(`${index + 2}-${filename}`);
  }
  /*eslint-enable no-await-in-loop*/
}

save().catch(error => {
  console.log(error.message);
});