Excel driver mmsheet not working (Windows 11)

Could you share an example of what is going wrong for you? Also, have you tried to use the mmsheet.xls or xlsx I/O driver instead of mmsheet.excel? And which version of Xpress / Mosel are you working with?

Dear Susanne,

I’ve attached an example that doesn’t work for me now, but it did work about 1-2 months ago. I'm using Xpress 8.14 on Win 11.

I get: Mosel: E-22: I cannot open file `mmsheet.xlsx:Data_IN.xlsx' for reading (Element not found).

Thanks

David Francas

P.S. When using CSV (with slight modifications to the code of course), everything runs without issues.

Dear David,

The issue you are reporting is not reproducing for me (I have tested with the latest Rel 9.6 of Xpress and equally with 8.14.0 and 8.14.2 on Windows 11). The error message is issued by the libxl library that is used by the mmsheet.xslx I/O driver to access the file: it fails to process the file - there could be various reasons for this, including a somehow damaged or modified source file or insufficient space in the temporary location where the xlsx file is uncompressed by libxl.