Function assertDate

test/testCsvIn.js:28–62

(address, cell, expected)

// };

const assertDate = function(address, cell, expected) {
  assert(
    cell.type === Excel.ValueType.Date,
    `expected ${address} type to be Date, was ${cell.type}`
  );
  assert(
    cell.value instanceof Date,
    `expected  value ${address} to be a Date, was ${cell.value}`
  );
  const {value} = cell;
  assert(
    value.getYear() === expected.getYear(),
    `expected ${address} Year to be ${expected.getYear()}, was ${value.getYear()}`
  );
  assert(
    value.getMonth() === expected.getMonth(),
    `expected ${address} Month to be ${expected.getMonth()}, was ${value.getMonth()}`
  );
  assert(
    value.getDay() === expected.getDay(),
    `expected ${address} Day to be ${expected.getDay()}, was ${value.getDay()}`
  );
  assert(
    value.getHours() === expected.getHours(),
    `expected ${address} Hour to be ${expected.getHours()}, was ${value.getHours()}`
  );
  assert(
    value.getMinutes() === expected.getMinutes(),
    `expected ${address} Minute to be ${expected.getMinutes()}, was ${value.getMinutes()}`
  );
  assert(
    value.getSeconds() === expected.getSeconds(),
    `expected ${address} Second to be ${expected.getSeconds()}, was ${value.getSeconds()}`
  );
};

const options = {
  dateFormats: ['DD/MM/YYYY HH:mm:ss'],