How to find the last row in a column using openpyxl normal workbook

Question

I'm doing data validation to all rows that include "Default" using openpyxl. However, I need to know how many rows there are in order to do that.

I am aware that there is a way to accomplish that if I were using iterable workbook mode, but I also want to add a new sheet to the workbook, which is not possible in iterable mode.

Answer 1

ws.max_row will give you the number of rows in a worksheet.

Since version openpyxl 2.4 you can also access individual rows and columns and use their length to answer the question.

len(ws['A'])

Though it's worth noting that for data validation for a single column Excel uses 1:1048576.