We regularly receive XLS files from our customers which are XML. This file contains the addition “XMLDATA” in the first line.
Excel can handle it and only notices that not all Feautures are usable.
In version 19.1.0 (.NET) we could not read the file because Cells threw an InvalidOperationException.
In version 19.5.0 (.NET) the file goes suddenly. Everything is correct except that the sheet name is not read correctly. Cells says that the sheet name is equal to the file name.
Please look at the sample file:
XMLDataSheet.zip (544 Bytes)