excel.js

excel.js copied to clipboard

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 need a little bit more of info here. What modules does workbook come from? I don't see in the code where excel is being used.