const Excel = require('../excel'); const [, , inputFile, outputFile] = process.argv; const wb = new Excel.Workbook(); let passed = true; const assert = function(value, failMessage, passMessage) { if (!value) { if (failMessage) { console.error(failMessage); } passed = false; } else if (passMessage) { console.log(passMessage); } }; // assuming file created by testBookOut wb.xlsx .readFile(inputFile) .then(() => { console.log('Loaded', inputFile); wb.eachSheet(sheet => { console.log(sheet.name); }); const ws = wb.getWorksheet('Sheet1'); assert(ws, 'Expected to find a worksheet called sheet1'); ws.getCell('B1').value = new Date(); ws.getCell('B1').numFmt = 'hh:mm:ss'; ws.addRow([1, 'hello']); return wb.xlsx.writeFile(outputFile); }) .then(() => { assert(passed, 'Something went wrong', 'All tests passed!'); }) .catch(error => { console.error(error.message); console.error(error.stack); });