I am trying to write (also update) in an excel file. But, the values are not updating in the file. Can you please help
My code is :
workbook.xlsx.readFile("DumyExcelFile.xlsx").then(function () {
var worksheet = workbook.getWorksheet('Sheet1');
var row = worksheet.getRow(6);
console.log(row.getCell(1).value);
row.getCell(1).value = 5;
row.getCell(2).value = 10;
worksheet.getRow(6).commit();
console.log(row.getCell(1).value,row.getCell(2).value);
});
Can you please guide me.
I am trying to write (also update) in an excel file. But, the values are not updating in the file. Can you please help
My code is :
workbook.xlsx.readFile("DumyExcelFile.xlsx").then(function () {
var worksheet = workbook.getWorksheet('Sheet1');
var row = worksheet.getRow(6);
console.log(row.getCell(1).value);
row.getCell(1).value = 5;
row.getCell(2).value = 10;
worksheet.getRow(6).commit();
console.log(row.getCell(1).value,row.getCell(2).value);
});
Can you please guide me.