``` import xlrd from datetime import datetime from xlrd import xldate_as_tuple # 同步訂單詳細信息 book = xlrd.open_workbook("order.xlsx") sheet = book.sheet_by_name("sheet1") for r in range(1, sheet.nrows): sql = "INSERT INTO tmp_order (`id`, `order_no`, `venue_name`, `user_name`, `student`, `card_no`, `add_time`, `business_type`, `des`, `pay_type`, `phone`, `ticket_num`) VALUES " order_no = sheet.cell(r, 0).value venue_name = sheet.cell(r, 1).value user_name = sheet.cell(r, 2).value student = sheet.cell(r, 3).value card_no = sheet.cell(r, 4).value #日期類型不轉float ctype = sheet.cell(r,5).ctype add_time = sheet.cell(r, 5).value if ctype == 3: date = datetime(*xldate_as_tuple(add_time, 0)) add_time = date.strftime('%Y/%m/%d %H:%M:%S') business_type = sheet.cell(r, 6).value des = sheet.cell(r, 7).value pay_type = sheet.cell(r, 12).value phone = sheet.cell(r, 17).value ticket_num = sheet.cell(r, 20).value //其他過濾邏輯 values = "(NULL,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');" % ( order_no, venue_name, user_name, student, card_no, add_time, business_type, des, pay_type, phone, ticket_num) execute_sql = sql + values # print (execute_sql); # if r==2:quit() with open('tmp_order.sql', mode='a', encoding='utf-8') as filename: filename.write(execute_sql) filename.write('\n') # 換行`