How to read only visible sheets

Question

How to read only visible sheets

Opened this issue 10 months ago · 2 comments

Kuramdasu-ujwala-devi commented 10 months ago

I have a use case wher ei wanted to read the content only if the sheet is visible i shouldn't read the hidden values.
Is there any parameter for this to toggle?

Answer 1 · 2024-02-09T10:05:26.000Z

This is exactly the same usecase we have, but there doesn't seem to be any way to get the "visibility" property through pyxlsb.

Answer 2 · 2024-03-20T12:14:13.000Z

But in pyxlsb2 that is possible, But reading all type of files is not possible. These are the corner cases of these 2 libraries. Got stuck because of these corner case.