1.准备:
使用之前需要先按照:打开cmd,输入pip install xlrd(xlswriter),点击enter;
2.基本使用:
xlrd:
#打开els文件,参数是文件路径:
table = xlrd.open_workbook(r"F:/selenium/test.xls")
sheet = table.sheets()[2] #通过索引顺序获取
sheet = table.sheet_by_index(0) #通过索引获取
sheet = table.sheet_by_name("Sheet1") #通过名称获取
#获取总行数:
nrows = sheet.nrows
#获取总列数:
ncols = sheet.ncols
#获取特定一行或一列的值,参数是第几行:
sheet.row_values(0) #获取第一行的值
sheet.col_values(0)#获取第一列的值
获取某一单元格里面的值:
#获取单元格:
cell_A1 = sheet.cell(0,0) .value
cell_C4 = sheet.cell(2,3).value
#使用行列索引:
cell_A1 = sheet.row(0)[0].value
cell_C4 = sheet.row(3)[2].value
cell_A2 = sheet.col(0)[1].value
1 #coding:utf-8 2 import xlrd 3 4 class ExcelUnit(): 5 def __init__(self,excelPath, sheetName): 6 self.data = xlrd.open_workbook(excelPath) 7 self.table = self.data.sheet_by_name(sheetName) 8 #获取第一行作为key值 9 self.keys = self.table.row_values(0) 10 #获取总行数 11 self.rowNum = self.table.nrows 12 #获取总列数 13 self.colNum = self.table.ncols 14 15 def dict_data(self): 16 if self.rowNum <= 1: 17 print("总行数小于1") 18 else: 19 r = [] 20 j = 1 21 for i in range(self.rowNum - 1): 22 s = {} 23 #从第二行取对象的values值 24 values = self.table.row_values(j) 25 for x in range(self.colNum): 26 s[self.keys[x]] = values[x] 27 r.append(s) 28 j += 1 29 return r 30 31 if __name__ == "__main__": 32 filepath = r"F:\Workspace\selenium\2_58xlrd\userdata.xls" 33 sheetName = "Sheet1" 34 data = ExcelUnit(filepath, sheetName) 35 36 print data.dict_data()
参考文档;
https://www.cnblogs.com/ysjt/p/6527056.html
http://www.cnblogs.com/yoyoketang/p/6701950.html