update A set A.01 = 'excel第一列的值' where A.02 = 'excel第二列的值'

#coding=utf-8from openpyxl import load_workbook#第一套servicebus.t_spis_servicebus_svcmain表的#讀取excel的數據def read_excel():  #打開一個workbook  wb = load_workbook(filename='xxx.xlsx')  #獲取所有表格（worksheet）的名字  sheets = wb.get_sheet_names()  #遍歷每一個sheet，并且拿到worksheet對象  for i in range(len(sheets)):    ws = wb.get_sheet_by_name(sheets[i])    #聲明list    list_A_B = []    #遍歷A，B列的所有數據值,ws.max_row:獲取最大行數    for rowNum in range(1,ws.max_row+1):      if (ws.cell(row=rowNum,column=1).value != None) and (ws.cell(row=rowNum,column=2).value != None):        #ws.cell(row=rowNum,column=1).value:拿到指定列的行數據        sql = 'update A set A.01=' + "'" + ws.cell(row=rowNum,column=1).value + "' " + 'where A.02=' + "'" + ws.cell(row=rowNum,column=2).value + "'"+ ';'        list_A_B.append(sql)    #print(list_A_B)    text_save(list_A_B,'A.txt')    print(str(sheets[i]) + '已完成！')   print('執行成功！')#將讀取的數據存入txt文檔中def text_save(content,filename,mode='a'):  #打開文件  file = open(filename,mode)  for i in range(len(content)):    number = content[i] + '/n'    file.write(number)  file.close()if __name__ == '__main__':  read_excel()