<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>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                [TOC] **前言** 當登錄的賬號有多個的時候,我們一般用excel存放測試數據,python讀取excel方法,并保存為字典格式。 ## **一、環境準備** 1. 先安裝xlrd模塊,打開cmd,輸入pip3 install xlrd在線安裝 ``` >>pip3 install xlrd ``` <br /> ## **二、基本操作** 1. exlce基本操作方法如下 ``` import xlrd # 打開excel表格 data = xlrd.open_workbook("C:/Users/aipu/Desktop/工作簿1.xlsx") table = data.sheet_by_name("Sheet1") nrows = table.nrows # 獲取總行數 ncols = table.ncols # 獲取總列數 print(table.row_values(0)) # 獲取第一行值 print(table.col_values(0)) # 獲取第一列值 ``` <br /> ## **三、excel存放數據** 1. 在excel中存放數據,第一行為標題,也就是對應字典里面的key值,如:username,password 2. 如果excel數據中有純數字的一定要右鍵》設置單元格格式》文本格式,要不然讀取的數據是浮點數 (先設置單元格格式后編輯,編輯成功左上角有個小三角圖標) ![](https://img.kancloud.cn/40/53/4053c845b787d19d7bb7c9624e74bc95_966x604.png) <br /> ## **四、封裝讀取方法** 1. 最終讀取的數據是多個字典的list類型數據 2. 封裝好后的代碼如下 ``` import xlrd class ExcelUtil(): def __init__(self, excelPath, sheetName): self.data = xlrd.open_workbook(excelPath) self.table = self.data.sheet_by_name(sheetName) # 獲取第一行作為key值 self.keys = self.table.row_values(0) # 獲取總行數 self.rowNum = self.table.nrows # 獲取總列數 self.colNum = self.table.ncols def dict_data(self): if self.rowNum <= 1: print("總行數小于1") else: r = [] j = 1 for i in range(self.rowNum -1): s = {} # 從第二行取對應values值 values = self.table.row_values(j) for x in range(self.colNum): s[self.keys[x]] = values[x] r.append(s) j += 1 return r if __name__ == "__main__": filepath = "C:/Users/aipu/Desktop/工作簿1.xlsx" sheetNmme = "Sheet1" data = ExcelUtil(filepath, sheetNmme) print(data.dict_data()) ``` 運行結果: ``` [{'username': 'python', 'password': '123456'}, {'username': 'selenium', 'password': '123'}, {'username': 'appium', 'password': '1234'}] ```
                  <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>

                              哎呀哎呀视频在线观看