<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ``` 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') # 換行`
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看