Openpyxl check for empty cell

by

To do something when cell is not empty add:

if cell.value:

which in python is the same as if cell value is not None (i.e.: if not cell.value == None:)

Note to avoid checking empty cells you can use

worksheet.get_highest_row()

and

worksheet.get_highest_column()

Also I found it useful (although might not be a nice solution) if you want to use the contents of the cell as a string regardless of type you can use:

unicode(cell.value)

More Related Contents:

  1. How does Python 2 compare string and int? Why do lists compare as greater than numbers, and tuples greater than lists?
  2. How to access object attribute given string corresponding to name of that attribute
  3. Spawning multiple instances of the same object concurrently in python
  4. Check if all elements in a list are identical
  5. Check if two unordered lists are equal [duplicate]
  6. super() fails with error: TypeError “argument 1 must be type, not classobj” when parent does not inherit from object
  7. Python dictionary from an object’s fields
  8. Python comparison operators chaining/grouping left to right?
  9. Iterate over Worksheets, Rows, Columns
  10. How can I separate the functions of a class into multiple files?
  11. Using self.xxxx as a default parameter – Python
  12. python assign values to list elements in loop
  13. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  14. Modify an existing Excel file using Openpyxl in Python
  15. Python: max/min builtin functions depend on parameter order
  16. What does object’s __init__() method do in python? [duplicate]
  17. Python Counter Comparison as Bag-type
  18. Python openpyxl data_only=True returning None
  19. How to clone a Python generator object?
  20. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  21. How does a Python set([]) check if two objects are equal? What methods does an object need to define to customise this?
  22. How to make a copy of a 2D array in Python? [duplicate]
  23. getting the row and column numbers from coordinate value in openpyxl
  24. Python object attributes – methodology for access
  25. Get cell color from .xlsx
  26. How to write a list to Excel column?
  27. Is it possible to get an Excel document’s row count without loading the entire document into memory?
  28. What’s the difference between the square bracket and dot notations in Python?
  29. How to write to an existing excel file without breaking formulas with openpyxl?
  30. TypeError: Missing one required positional argument [duplicate]

Leave a Comment