读出Excel中的内容

 

#encodiing=utf-8
from openpyxl import load_workbook

class ParseExcel(object):
    def __init__(self,excelPath,sheetName):
        self.wb=load_workbook(excelPath)
        self.sheet=self.wb.get_sheet_by_name(sheetName)
        self.maxRowNum=self.sheet.max_row
        
        
    def getDatasFromSheet(self):
        dataList=[]
        for line in self.sheet.rows:
            tmpList=[]
            tmpList.append(line[0].value)
            tmpList.append(line[1].value)
            tmpList.append(line[2].value)
            dataList.append(tmpList)
            
        return dataList[1:]
        # return tmpList[1:]



if __name__=='__main__':
    excelPath=u'data.xlsx'
    sheetName=u"搜索数据表"
    pe=ParseExcel(excelPath,sheetName)
    print(pe.getDatasFromSheet())
    for i in pe.getDatasFromSheet():
        print (i[0], i[1])