Is there a way to get the number of rows and columns present in a .xlsx sheet using openpyxl?

Question

Is there a way to get the number of rows and columns present in a .xlsx sheet using openpyxl? In xlrd,

     sheet.ncols 
     sheet.nrows

will give the number of columns and rows. Is there such a method in openpyxl?

Answer 1

If sheetis the worksheet you want to find, the number of rows and columns you can do:

rows = sheet.max_row
column = sheet.max_column