exceljs
exceljs copied to clipboard
[BUG] Stream.xlsx.WorkbookReader skipping blank rows
🐛 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.