python遍历excel表

from openpyxl import load_workbook

def printXLSXInfo(self, xlsxFile):
    wb = load_workbook(filename=xlsxFile)
    errCounter = 0
    for x in wb:
      sheet_ranges = wb[x.title]
      for val in sheet_ranges.values:
        for prop in val:
          print(prop)

记得pip install openpyxl