Function createSimpleWorkbook

spec/unit/doc/workbook.spec.js:9–55

()

// Helpers

function createSimpleWorkbook() {
  const wb = new Excel.Workbook();
  const ws = wb.addWorksheet('blort');

  // plain number
  ws.getCell('A1').value = 7;
  ws.getCell('A1').name = 'Seven';

  // simple string
  ws.getCell('B1').value = 'Hello, World!';
  ws.getCell('B1').name = 'Hello';

  // floating point
  ws.getCell('C1').value = 3.14;

  // date-time
  ws.getCell('D1').value = new Date();
  ws.getCell('D1').dataValidation = {
    type: 'date',
    operator: 'greaterThan',
    showErrorMessage: true,
    allowBlank: true,
    formulae: [new Date(2016, 0, 1)],
  };
  // hyperlink
  ws.getCell('E1').value = {
    text: 'www.google.com',
    hyperlink: 'http://www.google.com',
  };

  // number formula
  ws.getCell('A2').value = {formula: 'A1', result: 7};
  ws.getCell('A2').name = 'TheFormula';

  // string formula
  ws.getCell('B2').value = {
    formula: 'CONCATENATE("Hello", ", ", "World!")',
    result: 'Hello, World!',
  };
  ws.getCell('B2').name = 'TheFormula';

  // date formula
  ws.getCell('C2').value = {formula: 'D1', result: new Date()};
  ws.getCell('C3').value = {formula: 'D1'};

  return wb;
}

// =============================================================================
// Tests