Cant read all xlsx file using openpyxl

Asked Mar 17 '22 at 10:45

Active Mar 17 '22 at 10:45

Viewed 668 times

It should be 35 rows, but it give me only 1, if i resave the excel file everything work correct

stat = openpyxl.load_workbook(filename=, read_only=True)
sheet = stat.active
print(sheet.max_row)

how can i solve this problem without resave? There is also error


UserWarning: Workbook contains no default style, apply openpyxl's default
  warn("Workbook contains no default style, apply openpyxl's default")

asked Mar 17 '22 at 10:45

Freerade

I try it myself with my own excel file and there is nothing wrong. maybe it has something to do with your excel file – dimas krisrianto Mar 17 '22 at 13:16
Yea it is, but i need to use these excel files. – Freerade Mar 17 '22 at 13:20
try pandas library. pandas can read excel too. pandas still need openpyxl to read xlsx but it's alternative that might solve your problem – dimas krisrianto Mar 17 '22 at 14:26
Please take a look at this: https://stackoverflow.com/questions/66214951/how-to-deal-with-warning-workbook-contains-no-default-style-apply-openpyxls – Ashish Samarth Mar 18 '22 at 02:36

0 Answers0