+5People love formatting excel documents so they're pretty and represent what they want, me doing it again for FME to understand, not so much.
It would be great if the excel reader could pick up if a column was hidden and add it to the Schema details, and if there was a Format Attribute that could indicate if a row was hidden.
Or actually an option to not read them at all would also be good.
+5These can be read out with the OpenPyXL library so something could be crafted, but it would be nice if it existed in native FME. https://stackoverflow.com/questions/31257353/finding-hidden-cells-using-openpyxl
+8Hi
We are looking into implementing a simple checkbox in the Excel reader, allowing you to ignore data in hidden rows and columns (height or width set to 0). Would that be sufficient for your use cases?
