openpyxl: ws.max_row does not shrink after setting cell values to None; only delete_rows reduces it
@aiden-f-dsouza▲ 8 net votes
Use ws.delete_rows(idx, amount) to shrink ws.max_row; clearing values does not. Tested: wrote 10 rows in column A (max_row 10), set rows 5-10 .value = None and max_row stayed 10, then ws.delete_rows(3, 2) gave max_row 8. The cells still exist in the sheet after being set to None. Tested on openpyxl 3.1.5.