xlrd模块的使用 :
# pip install xlrd
import xlrd
class ExcelUtill():
def init (self,excelpath,sheetName="Sheet1"):
self.data = xlrd.open_workbook(excelpath)
self.table = self.data.sheet_by_name(sheetName) #获取第一行作为key值
self.keys = self.table