Openpyxl max_row and max_column wrongly reports a larger figure

by

As noted in the bug report you linked to there’s a difference between a sheet’s reported dimensions and whether these include empty rows or columns. If max_row and max_column are not reporting what you want to see then you will need to write your own code to find the first completely empty. The most efficient way, of course, would be to start from max_row and work backwards but the following is probably sufficient:

for max_row, row in enumerate(ws, 1):
    if all(c.value is None for c in row):
        break

More Related Contents:

  1. Editing workbooks with rich text in openpyxl
  2. Pandas: Looking up the list of sheets in an excel file
  3. How to concatenate three excels files xlsx using python?
  4. How to copy worksheet from one workbook to another one using openpyxl?
  5. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  6. How to find the last row in a column using openpyxl normal workbook?
  7. how to write to a new cell in python using openpyxl
  8. Python openpyxl data_only=True returning None
  9. Insert row into Excel spreadsheet using openpyxl in Python
  10. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  11. Get cell color from .xlsx
  12. How to write to an existing excel file without breaking formulas with openpyxl?
  13. Setting styles in Openpyxl
  14. Export a list of stock prices to excel
  15. Writing to an Excel spreadsheet
  16. Convert Excel style date with pandas
  17. Iterate over Worksheets, Rows, Columns
  18. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  19. append dataframe to excel with pandas
  20. How to open a password protected excel file using python?
  21. .xlsx and xls(Latest Versions) to pdf using python
  22. Convert date from excel in number format to date format python [duplicate]
  23. How to obtain sheet names from XLS files without loading the whole file?
  24. Calling python script from excel/vba
  25. Modify an existing Excel file using Openpyxl in Python
  26. Merge rows based on value (pandas to excel – xlsxwriter)
  27. Write to StringIO object using Pandas Excelwriter?
  28. getting the row and column numbers from coordinate value in openpyxl
  29. django excel xlwt
  30. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets

Leave a Comment