Visibility of dataframe. - Pandas Python

Question

df = pd.read_excel("file_name.xlsb", sheet_name="sheetname")

Is it possible to check the df (DataFrame) visibility.

I have read the excel file (.xlsb) using pandas. I cannot use other libraries to check the sheet visibility. Since, I shall be do more changes if I change the library.

What do you mean by visibility? Do you just want to check columns and values, like you would see in Excel? — kynnemall, Apr 24 '20 at 12:16
You can find a solution here: https://stackoverflow.com/questions/56625728/openpyxl-check-if-worksheet-is-hidden — kynnemall, Apr 24 '20 at 12:22

score 0 · Answer 1 · answered Apr 24 '20 at 12:28

0

Using this code you can see if the sheet is hidden or not

import pandas as pd

xls = pd.ExcelFile('file_name.xlsb')

sheets = xls.book.sheets()

for sheet in sheets:
    print(sheet.name, sheet.visibility)

answered Apr 24 '20 at 12:28

kynnemall

855
9
26

It doen;t support xlsb file – Vineesh TP Apr 24 '20 at 13:19

Visibility of dataframe. - Pandas Python

1 Answers1