• File: test2.js
  • Full Path: /var/www/nodejs/daily_store_reports_nodejs/test2.js
  • Date Modified: 02/04/2023 9:30 PM
  • File size: 722 bytes
  • MIME-type: text/plain
  • Charset: utf-8
var Excel = require('exceljs');
var workbook = new Excel.Workbook();

workbook.xlsx.readFile('temp1.xlsx')
.then(function() {
    var worksheet = workbook.getWorksheet(1);
    var row = worksheet.getRow(6);
    row.getCell(2).value = '153436576579870988'; // A5's value set to 5
    row.getCell(3).value = 'Bizimana'; // A5's value set to 5
    row.getCell(4).value = 6582; // A5's value set to 5
    row.getCell(5).value = 'Pagamento de roupa'; // A5's value set to 5
    row.getCell(6).value = 'Pagamento de roupa'; // A5's value set to 5
    row.getCell(7).value = 'C'; // A5's value set to 5
    row.getCell(8).value = 'MZN'; // A5's value set to 5
    row.commit();
    return workbook.xlsx.writeFile('new2.xlsx');
})