Thursday, 11 May 2017

I want to write in to .xlsx file with xlsx.write() function, XLSX npm module can any one help me out?

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