exceljs icon indicating copy to clipboard operation
exceljs copied to clipboard

[BUG] Stream.xlsx.WorkbookReader skipping blank rows

Open PAllisonVSO opened this issue 1 year ago • 0 comments

🐛 Bug Report

When reading through an excel file using excelJs.stream.xlsx.WorkbookReader, the stream completely skips blank rows. I am unclear if this is working as intended, but the non-streaming does not behave this way.

Lib version: 4.4.0

Steps To Reproduce

You can use the attached excel file example with the code below to see this issue: SkipLinesExample.xlsx

const readStream = fs.createReadStream(filePath);
const workbookReader = new excelJs.stream.xlsx.WorkbookReader(readStream, {});

for await (const worksheetReader of workbookReader) {
  for await (const row of worksheetReader) {
    console.log(row.number);
  }
}

You will get row 1, 6, 7, 8...

The expected behavior:

I expected to get row 1, 2, 3, 4, 5, 6, 7, 8...

If this is working as expected, please point me to the documentation that clarifies that, and I apologize for not being able to find it.

PAllisonVSO avatar Jun 06 '24 13:06 PAllisonVSO