I am trying to delete the first rows, but i don't always know how many rows to delete.

I need to delete all the rows until the first cell on the first column is called "Account"

I made the following:

import openpyxl

wb=load_workbook('abcd.xlsx')
ws=wb.active

mr=ws.max_row
mc=ws.max_column

for row in ws.iter_rows():
    for i in range(1,mr 1):
        if ws.cell(row=i,column=1).value=='Account':
            first_row=ws.cell(row=i,column=1).value=='Account'

ws.delete_rows(1,first_row-1)


wb.save('example.xlsx')

It just deletes all the data from the excel

CodePudding user response：

Try this

import openpyxl

filename = "abcd.xlsx"
wb = openpyxl.load_workbook(filename)
sheet = wb['Sheet1']
status = sheet.cell(sheet.min_row, 1).value
print(status)
sheet.delete_rows(sheet.min_row, 1)
wb.save(filename)

CodePudding user response：

Try this and see how it works for you. It's good to delete rows in a reverse order because if not you end up (for example) removing row 2, then move onto row 3, but the problem is now that what was row 3 has become row 2 and you're one step too far.

Edited to say: If you have a great number of rows to delete, you're generally better off collecting all the good rows and writing them to a new workbook. delete_rows isn't terribly quick.

import openpyxl

wb = openpyxl.load_workbook('abcd.xlsx')
ws = wb.active

mr = ws.max_row 1
mc = ws.max_column


def FindFirstAccount():

    rowsToDelete = []
    for cell in ws['A2':f'A{mr}']:
        for thisString in cell:
            if thisString.value != 'Account':
                rowsToDelete.append(thisString.row)
            else:
                return rowsToDelete


rowsToDelete = FindFirstAccount()


for row in reversed(rowsToDelete):
    ws.delete_rows(row)


wb.save('example.xlsx')