Guest User

Untitled

a guest
Oct 18th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. var Excel = require('exceljs');
  2. var workbook = new Excel.Workbook();
  3.  
  4. workbook.xlsx.readFile('Book.xlsm')
  5. .then(function () {
  6. var worksheet = workbook.getWorksheet(1);
  7. var row = worksheet.getRow(1);
  8. console.log(row.getCell(1).value + " - First value"); // Get A1 value
  9. row.getCell(3).value = "c"; //Set value to A3
  10. row.commit();
  11. return workbook.xlsx.writeFile('new.xlsm');
  12. })
Add Comment
Please, Sign In to add comment