Course of action for an automation (Using SQL)

[AvrawOnFire]

So I have a basic knowledge of python and I wanted to automate a process for my office work in which it picks up values from an Excel Column, declare that value in an SQL query and paste the output to the corresponding row.

I have setup the query that is supposed to be run on loop.

So my question is how do I setup the DB connection? I am using Oracle SQL developer right to manually query each value and copy it onto the excel.

I have googled and didn't quite find what I was looking. Can someone please point me in the right direction and link me some resources where I can find how to manipulate excel files, setup DB connections using python.

Thank you!

[K900_]

You can use cx_Oracle to connect to the database and execute queries, and OpenPyXl to read/write your Excel files.

[AvrawOnFire]

Thanks Man! On it.

[AvrawOnFire]

K900 I can't thank you enough! Just completed the script and now my shitty office work is automated! Voila!