Python Forum
Deleting rows based on cell value in Excel
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Deleting rows based on cell value in Excel
#11
PyCharm does not change how Python programs work. The program contains an error. It will run fine for some worksheets and crashes on others. This is the error:
if 'X' in row[1].value or 'x' in row[1].value:
If row[1] is an int (or other non-iterable), this will raise an error.
Error:
TypeError: argument of type 'int' is not iterable
Your program should check the cell value type before treating it like a string.
import openpyxl

def remove_x(src_file, dst_file):
    """Removes rows that contain X or x"""
    workbook = openpyxl.load_workbook(src_file)
    for sheet in workbook:
        for row in sheet.iter_rows():
            for cell in row:
                value = cell.value
                if isinstance(value, str) and "x" in value.lower():
                    sheet.delete_rows(cell.row)
                    break
    workbook.save(dst_file)

remove_x("data.xlsx", "modified.xlsx")
Reply
#12
Thanks will have another play based on your reply.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy Paste excel files based on the first letters of the file name Viento 2 346 Feb-07-2024, 12:24 PM
Last Post: Viento
  Color a table cell based on specific text Creepy 11 1,822 Jul-27-2023, 02:48 PM
Last Post: deanhystad
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,798 Dec-12-2022, 08:22 PM
Last Post: jh67
  How to assign a value to pandas dataframe column rows based on a condition klllmmm 0 797 Sep-08-2022, 06:32 AM
Last Post: klllmmm
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,599 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  Calculate next rows based on previous values of array divon 0 1,716 Nov-23-2021, 04:44 AM
Last Post: divon
  Using Excel Cell As A Variable In A Loop knight2000 7 4,012 Aug-25-2021, 12:43 PM
Last Post: snippsat
  Using Excel Cell As A Variable In A Loop knight2000 7 4,890 Jul-18-2021, 10:52 AM
Last Post: knight2000
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,080 May-04-2021, 10:51 PM
Last Post: rhat398
Smile Set 'Time' format cell when writing data to excel and not 'custom' limors 3 6,195 Mar-29-2021, 09:36 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020