python 历遍工作薄_Python利用openpyxl库遍历Sheet的方法
方法一，利用 sheet.iter_rows() 获取Sheet1 表中的所有行，然后遍历
import openpyxl
wb = openpyxl.load_workbook(example.xlsx)
sheet = wb.get_sheet_by_name(Sheet1)
for row in sheet.iter_rows():
for cell in row:
print(cell.coordinate, cell.value)
print(--- END OF ROW ---)
sheet = wb.get_sheet_by_name(Sheet1)
for rowOfCellObjects in sheet[A1:C3]:
for cellObj in rowOfCellObjects:
print(cellObj.coordinate, cellObj.value)
print(--- END OF ROW ---)
方法二，利用 sheet.
max_rowsheet.
max_colum 获取 Sheet1 表中最大行和列的值，然后遍历
方法一，利用 sheet.iter_rows() 获取Sheet1 表中的所有行，然后遍历 import openpyxl wb = openpyxl.load_workbook(example.xlsx) sheet = wb.get_sheet_by_name(Sheet1) for row in sheet.iter_rows(): for cell in row: print(cell.coordinate, cell.value) print(--- END OF ROW ---) sheet = wb.get_sheet_by_name(Sheet1) for rowOfCellObjects in sheet[A1:C3]: for cellObj in rowOfCellObjects: print(cellObj.coordinate, cellObj.value) print(--- END OF ROW ---) 方法二，利用 sheet. max_rowsheet. max_colum 获取 Sheet1 表中最大行和列的值，然后遍历