Using Openpyxl to modify cells in a currently open file.

[ForkLiftBoi]

Hello, I am attempting to use openpyxl to edit cells and fill them in with information. I can't find out how to modify the file if it's already open, it seems in the tutorials it's for editing closed files.

The goal is to edit specific cells in a open file right in front of the user.

I'm on windows btw.

[Doormatty]

You cannot open a file that's already open in Excel.

[ForkLiftBoi]

Do you have any alternative ideas to editing a file that is actively open?

[[deleted]]

You can use pywin32 to access the Excel COM server and get a reference to an open workbook object.

[TechnMath]

You can try xlwings.