pywin32

[joedata]

A python module called pywin32 enables users to read an excel file, make changes to specific cells, execute a Refresh All which refreshes all the data connections, and save the changes made to an excel file. This cannot be used on databricks because of the os. These are the requirements we need from our code in order to remove manual steps in the data flow between models which would drastically improve efficiency, robustness, and accuracy of data being inputted into the models. 

We can read the excel file through Volumes, and we can make some changes to cells. But we are struggling with overwriting the file with the newly edited excel and pushing the file to execute a Refresh All function through code on databricks. 

I appreciate that this is quite a unique issue that we're facing, but any advice would appreciated

[Kaniz_Fatma]

Hi @joedata, 

• Since Databricks notebooks allow you to run Python code, you can leverage Python libraries to manipulate Excel files.
• Instead of using pywin32, consider using libraries like pandas or openpyxl to read, modify, and save Excel files.
• You can install these libraries in your Databricks environment using %pip install pandas openpyxl.