file parsed incorrectly

[unxed]

Паспорт Отделений 12.11.2024.xlsx

[unxed]

The file should be read as an array of data, with each row containing colls:

• address
• code
• geographic coordinates.

However, I'm receiving lines with the region name in the first column, the city name in the second, and the third column empty. If I open this file in LibreOffice and save it under a different name, it is processed correctly.

[shuchkin]

There hidden sheets, use print_r($xlsx->rows(2));

https://opencollective.com/simplexlsx

[unxed]

Thanks!

[unxed]

Is there any way do detect hidden sheets presence and skip them automatically?

[shuchkin]

Auto skipping hidden sheets will break the logic of reading data from the book
see isHiddenSheet and sheetMetaData
https://github.com/shuchkin/simplexlsx/blob/master/src/SimpleXLSX.php#L1138