Download below libraries to your python.

  1. pip install csv
  2. pip install openpyxl
import openpyxl
import cx_Oracle

#Oracle connection starts here
# connection = cx_Oracle.connect("<schema>", "<pwd>", "<hostname>/<sid/service>")
print("Database version:", connection.version)
print(cx_Oracle.version)
print(connection.current_schema)
print("Creating a Table")
from sys import modules
cursor = connection.cursor()
from openpyxl import Workbook
wb = openpyxl.load_workbook('Load.xlsx',data_only=True)
##wb = openpyxl.load_workbook(filename=Load.csv, read_only=True, **self.kwargs)
ws = wb['Sheet1']
x=1
m=1

# looping through each row for each column
for i in range(1, ws.max_row+1):
for j in range(2, ws.max_column+1):
ID= ws.cell(row=i, column=j).value
SYSTEM = ws.cell(row=i, column=j).value
PRINCIPAL = ws.cell(row=i, column=j).value
AGENT = ws.cell(row=i, column=j).value
MSO = ws.cell(row=i, column=j).value
SITE_NAME = ws.cell(row=i, column=j).value
LAST_CHG_DATETIME = ws.cell(row=i, column=j).value
LAST_CHG_OPER = ws.cell(row=i, column=j).value

insert_table = "INSERT INTO SITE (ITEM_ID, NAME, PRODUCT, CUST_ID, CUST_NAME, CUST_NAME, LAST_CHG_DATETIME, LAST_CHG_OPER)" + \
" VALUES (:1, :2, :3, :4, :5, :6, :7, :8)"

cursor.execute(insert_table, (ITEM_ID, NAME, PRODUCT, CUST_ID, CUST_NAME, CUST_NAME, LAST_CHG_DATETIME, LAST_CHG_OPER))
connection.commit()

connection.close()

Leave a comment