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'); })