Moving cells between cells in excel using python

Question

I need to move cell D3 to D4 in excel if cell A3 is not equal to C3 can anyone tell how to do this using python?

use pandas. can you share the excel file/data set?

chitown88
– chitown88

2022-08-30 08:59:37 +00:00
Commented Aug 30, 2022 at 8:59 — chitown88
– chitown88, Commented Aug 30, 2022 at 8:59

Laguilhoat · Accepted Answer · 2022-08-30 09:17:17Z

0

This will do exactly what you asked for:

import openpyxl

filename = 'table.xlsx'

wb = openpyxl.load_workbook(filename)
ws = wb.active

if ws['A3'] != ws['C3']:
    ws['D4'] = ws['D3'].value
    ws['D3'] = None

wb.save(filename)

Make sure not to have the file open in Excel while you do this, or you'll get permission errors. If you want to do this dynamically (while you have the file open) you'll have to use pywin32 which is slightly more challenging.

edited Aug 30, 2022 at 9:17

answered Aug 30, 2022 at 9:10

Laguilhoat

3231 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

Moving cells between cells in excel using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related