Skip to content

Instantly share code, notes, and snippets.

View HarcourtHamsa's full-sized avatar
:octocat:
Building

Harcourt Hamsa HarcourtHamsa

:octocat:
Building
View GitHub Profile
@sreepurnajasti
sreepurnajasti / readSheet.js
Created August 28, 2018 05:26
Reading xlsx, csv files using exceljs in node
var Excel = require('exceljs');
var workbook = new Excel.Workbook();
workbook.xlsx.readFile('../../storage/cust_88ae31d4-47c5-4f70-980e-7b473ba20ef9/xls.xls')
.then(function() {
var worksheet = workbook.getWorksheet('Sheet1');
worksheet.eachRow({ includeEmpty: true }, function(row, rowNumber) {
console.log("Row " + rowNumber + " = " + JSON.stringify(row.values));
});
});