delete content of particular Excel cells python

Question

I have the following Excel sheet with the following cells:

    'A'   'B'   'C' 
1    S     2     T
2    E     F     D
3    K     L     M
4    N     D     F
5    P     E     M

I would like to delete the first j lines from column 'B', where j is a list length.

list=['2','F','L']

Any idea how this can be accomplished?

I would prefer to use openpyxl for this action.

Best regards,

Dan

@MegaIng I was close enough from the first time, but I have tried a stupid method, so I posted the question here. Thanks anyway. — dante
– dante, Commented Jan 17, 2018 at 18:22

dante · Accepted Answer · 2018-01-17 18:20:47Z

4

Found out the solution. Maybe someone else would need it:

import openpyxl
wb=openpyxl.load_workbook('/media/sf_vboxshared/x.xlsx')
sheet=wb.get_sheet_by_name('Sheet1')
list=['2','F','L']
j=len(list)
for j in range(1,j+1):
        sheet.cell(row=j, column=2).value=None

And to check the output can be used:

for rowOfCellObjects in sheet['A1':'D6']:
        for cellObj in rowOfCellObjects:
                print(cellObj.coordinate, cellObj.value)

Best regards, Dan

answered Jan 17, 2018 at 18:20

dante

972 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

delete content of particular Excel cells python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related