Function "eachCell" does not work as expected about exceljs HOT 4 CLOSED

The eachRow and eachCell functions now support an optional options argument that will git you the behaviour you need...

worksheet.eachRow({ includeEmpty: true }, function(row, rowNumber) {
    row.eachCell{ includeEmpty: true }, function(cell, colNumber) {
        console.log("Cell " + colNumber + " on Row " + rowNumber + " = " + cell.value);
    });
});

from exceljs.

I just saw your sources files and see next:

eachRow: function(iteratee) {
        this._rows.forEach(function(row) {
            if (row.hasValues) {
                iteratee(row, row.number);
            }
        });
    },

For me, it is not expected behaviour, because if we have strong order of properties it will be wrong in the output.
Instead of your function eachRow I have to use this construction:

var parsedRow = {};
// here counting starts from 1
for (var col = 1; col < row.values.length; col++) {
      var cell = row.getCell(col);
      parsedRow[columnsRow.getCell(col).value] = cell.value;
}

from exceljs.

I guess the "each" functions could take an optional boolean argument like "includeEmpty" that would behave more like you want. I'll add it to the next release.

from exceljs.

Great, Thank you!

from exceljs.