Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
WIKIPEDIA
/
nodejs
/
daily_store_reports_nodejs
:
test2.js
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
var Excel = require('exceljs'); var workbook = new Excel.Workbook(); workbook.xlsx.readFile('temp1.xlsx') .then(function() { var worksheet = workbook.getWorksheet(1); var row = worksheet.getRow(6); row.getCell(2).value = '153436576579870988'; // A5's value set to 5 row.getCell(3).value = 'Bizimana'; // A5's value set to 5 row.getCell(4).value = 6582; // A5's value set to 5 row.getCell(5).value = 'Pagamento de roupa'; // A5's value set to 5 row.getCell(6).value = 'Pagamento de roupa'; // A5's value set to 5 row.getCell(7).value = 'C'; // A5's value set to 5 row.getCell(8).value = 'MZN'; // A5's value set to 5 row.commit(); return workbook.xlsx.writeFile('new2.xlsx'); })