Read/Write excel sheet using ExcelJS

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
var Excel = require('exceljs');
var wb = new Excel.Workbook();
wb.xlsx.readFile("./test.xlsx").then(function(){
    var sh = wb.getWorksheet("Sheet1");
  
    sh.getRow(3).getCell(2).value = 32;
    wb.xlsx.writeFile("./test.xlsx");
    console.log("Row-3 | Cell-2 - "+sh.getRow(3).getCell(2).value);
    console.log(sh.rowCount);
    //Get all the rows data [1st and 2nd column]
    for (i = 1; i <= sh.rowCount; i++) { 
        console.log(sh.getRow(i).getCell(1).value);
        console.log(sh.getRow(i).getCell(2).value);
    }
})
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX