打開(kāi)excel文件讀取數(shù)據(jù)

data = xlrd.open_workbook("excelFile.xls")

讀取工作表

table = data.sheets()[0] # 通過(guò)索引順序獲取

table = data.sheet_by_index(0) # 通過(guò)索引順序獲取

table = data.sheet_by_name(u'Sheet1') # 通過(guò)名稱(chēng)獲取

獲取整行和整列的值（數(shù)組）

table.row_values(i) #獲取整行值

table.col_values(i) #獲取整列的值

獲取行數(shù)和列數(shù)

nrows = table.nrows #獲取行數(shù)

ncols = table.ncols #獲取列數(shù)

###單元格

cell_A1 = table.cell(0,0).value

cell_C4 = table.cell(2,3).value

使用行列索引

cell_A1 = table.row(0)[0].value

cell_A2 = table.row(1)[0].value

            
              
                # -*- coding: utf-8 -*-
              
              
                import
              
               xlrd



              
                def
              
              
                excel_data
              
              
                (
              
              
                file
              
              
                =
              
              
                'test.xls'
              
              
                )
              
              
                :
              
              
                try
              
              
                :
              
              
                # 打開(kāi)Excel文件讀取數(shù)據(jù)
              
              
        data 
              
                =
              
               xlrd
              
                .
              
              open_workbook
              
                (
              
              
                file
              
              
                )
              
              
                # 獲取第一個(gè)工作表
              
              
        table 
              
                =
              
               data
              
                .
              
              sheet_by_index
              
                (
              
              
                0
              
              
                )
              
              
                # 獲取行數(shù)
              
              
        nrows 
              
                =
              
               table
              
                .
              
              nrows
        
              
                # 獲取列數(shù)
              
              
        ncols 
              
                =
              
               table
              
                .
              
              ncols
        
              
                # 定義excel_list
              
              
        excel_list 
              
                =
              
              
                [
              
              
                ]
              
              
                for
              
               row 
              
                in
              
              
                range
              
              
                (
              
              
                0
              
              
                ,
              
               nrows
              
                )
              
              
                :
              
              
                for
              
               col 
              
                in
              
              
                range
              
              
                (
              
              ncols
              
                )
              
              
                :
              
              
                # 獲取單元格數(shù)據(jù)
              
              
                cell_value 
              
                =
              
               table
              
                .
              
              cell
              
                (
              
              row
              
                ,
              
               col
              
                )
              
              
                .
              
              value
                
              
                # 把數(shù)據(jù)追加到excel_list中
              
              
                excel_list
              
                .
              
              append
              
                (
              
              cell_value
              
                )
              
              
                return
              
               excel_list
    
              
                except
              
               Exception 
              
                as
              
               e
              
                :
              
              
                print
              
              
                (
              
              
                str
              
              
                (
              
              e
              
                )
              
              
                )
              
              
                if
              
               __name__ 
              
                ==
              
              
                "__main__"
              
              
                :
              
              
                list
              
              
                =
              
               excel_data
              
                (
              
              
                )
              
              
                for
              
               i 
              
                in
              
              
                list
              
              
                :
              
              
                print
              
              
                (
              
              i
              
                )