🐛 Bug Report

We have an excel which is generated with python openpyxl and adds a sheet named "test":

When trying to read this excel via exceljs streaming api, it doesn't return the correct sheet names, but "Sheet1", "Sheet2".

Steps To Reproduce

• Download this excel or generate it yourself using the following python code:

from openpyxl import Workbook

wb = Workbook()

test = wb.create_sheet("test")
test["A1"] = "new value"

wb.save("test.xlsx")

• Execute the following js code

const Excel = require("exceljs");
const fs = require("fs/promises");
const path = require("path");

const run = async () => {
  const file = await fs.open(path.join(__dirname, "test.xlsx"));
  const fileStream = file.createReadStream();
  const workbookReader = new Excel.stream.xlsx.WorkbookReader(fileStream, {});
  for await (const worksheetReader of workbookReader) {
    console.log(worksheetReader.name);
  }
};
run();

• console.log returns "Sheet1" and "Sheet2" but should return "Sheet1" and "test"

Within workbookRead.model.sheets the sheet name is provided. So I could look it up using

const sheetInfo = workbookReader.model.sheets.find((sheet) => sheet.id == worksheetReader.id);
console.log(sheetInfo.name);

Here the issue is that the behaviour is very nondeterministic and workbookRead.model is not always defined.

When not using the streaming API, the sheets are resolved correctly. So it seems the issue is not within the excel itself:

const workbook = new Excel.Workbook();
await workbook.xlsx.readFile(path.join(__dirname, "test.xlsx"));
workbook.eachSheet((sheet) => {
  console.log(sheet.name);
});

The expected behaviour:

The streaming API should return the correct sheet names using the streaming API.

Possible solution (optional, but very helpful):

n/a