from openpyxl import Workbook
from openpyxl import load_workbook
import mysql.connector
import psycopg2
import datetime
import json

plm_db = psycopg2.connect(host="host",user="user",password="password",database="database",port="port")
plm_cursor = plm_db.cursor()

wb = load_workbook(filename='S3(1).xlsx')

sheet_ranges = wb['Sheet1']

rowCount = sheet_ranges.max_row

processData=[]

for row in sheet_ranges.iter_rows(min_row=2,max_row=rowCount,values_only=True):
    processData.append({"materialcode": row[0],"worktime":row[1]})

    sql = '''update a set macht=%s
        from b,c
        where b.itemid2=a.id and
        c.id=b.itemid1 and c.wkaid<>'3' and c.del=0 and c.sel=1 and
        c.no='%s' and a.wkaid<>'3' and a.del=0'''%(row[1],row[0])

    print(sql)

    plm_cursor.execute(sql)
    plm_db.commit()

plm_cursor.close();
plm_db.close();