I was trying to read an excel sheet from nodejs and would like to insert a value to a particular cell of my excel sheet. I tried the below code. But it gives me error
const XLSX = require('xlsx');
let workbook = XLSX.readFile('newTest.xlsx');
let first_sheet_name = workbook.SheetNames[0];
let worksheet = workbook.Sheets[first_sheet_name];
let cell = worksheet['AW2'].v;
console.log(cell)
worksheet['AW2'].v = 'test';