I want to write in to .xlsx file with xlsx.write() function with XLSX npm module can any one help me out?
With the below code i am able to write the file but it doesn't work as expected :
var XLSX = require('xlsx');
var workbook = XLSX.readFile("path of the file");
var first_sheet_name = workbook.SheetNames[0];
var worksheet = workbook.Sheets[first_sheet_name];
worksheet['G12']={t:"n" ,v:100107};
XLSX.writeFile(workbook,"path of the file")
via Shiva Kumar
No comments:
Post a Comment