[BUG FsSpreadsheet.Exceljs] ClosedXml files cannot be read from exceljs

[Freymaurer]

Test is commented out in tests/JS/Exceljs.

Opening and saving the file will make the test pass. THIS is not the behaviour we want, therefore never save the file

[omaus]

Not directly about the issue but about the wording: ClosedXML is a library that uses OpenXML, as we do. But we do not have anything to do with ClosedXML, so it'd be better to get rid of their name here before any misunderstandings happen. 😅
@Freymaurer what you meant is probably OpenXML

[Freymaurer]

No it is on purpose. We should thrive to suppot read in of files produced by openxml/closedxml/exceljs

[Freymaurer]

In tests/JS/Exceljs:

// TypeError: Cannot read properties of undefined (reading 'company')
it('ClosedXml.Table', async () => {
    const path = "tests/JS/TestFiles/ClosedXml.Table.xlsx";
    const fswb = await Xlsx.fromXlsxFile(path)
    let worksheets = fswb.GetWorksheets()
    equal(worksheets.length, 1)
});

[Freymaurer]