I have test.xlsb file in that few rows are hidden. When I use the pyxlsb lib I can able to skip the empty rows. Is there any command to find the hidden number of hidden rows.?
from pyxlsb import open_workbook
wb = open_workbook(test.xlsb)
wb_sheet = wb.get_sheet('Test')
wb_sheet.rows(sparse=False)
or do we have any pandas command to ignore the hidden rows
excel_df = pd.read_excel(test.xlsb, engine='pyxlsb', sheet_name='Test', skiprows=1, secols=colum_to_read)