Python: Read Existing Excel File And Select A Different Dropdown Value

I want to be able to open an xlsx file in Python and select a different dropdown value in a cell which should trigger an update for the entire spreadsheet based on the new value (j

Solution 1:

TL;DR: You can't.

In order to get cascading execution, you need to access the Excel execution engine. Python libraries do not have a copy of this.

If you wish to change additional values in the spreadsheet, you will need to write your Python code to make the changes.

Caveat: There technically is a way to do it using pywin32 if you have a version of Excel installed. In this case Python is simply feeding instructions to Excel, no differently than if you were using VBA. It is significantly more complicated than changing a value using a library such as Openpyxl.