Is there a way to make python and excel interact?

Asked May 17 '19 at 14:19

Active May 17 '19 at 14:19

Viewed 79 times

I have a dropdown option on excel. I want that when the user inputs something on that dropdown, my python script automatically starts running and enters the output into the excel file.

I know how to make python read and write into excel files and that part of the code works fine. However, I have difficulty automating the process.

Is there a way for python to automatically start running?

asked May 17 '19 at 14:19

Ray234

There: https://openpyxl.readthedocs.io/en/stable/ – olinox14 May 17 '19 at 14:24
1

I think this link should be useful for what you're trying to do: https://stackoverflow.com/questions/18135551/how-to-call-python-script-on-excel-vba – Hampus Larsson May 17 '19 at 14:26
Also this: https://www.xlwings.org/ – Connor Ferster May 17 '19 at 14:28

Is there a way to make python and excel interact?

0 Answers0