python_excel_openpyxl_遍历sheet工作表名

21fanqie

python_excel_openpyxl_遍历sheet工作表名

from openpyxl import workbook
from openpyxl import load_workbook
from openpyxl import worksheet

wb = load_workbook("test.xlsx")
all_sheets = wb.get_sheet_names()
print(all_sheets)

for i in range(len(all_sheets)):
    sheet = wb.get_sheet_by_name(all_sheets)
    print(sheet.title + ': max_row: ' + str(sheet.max_row) + ' max_column: ' + str(sheet.max_column))

来自：https://blog.csdn.net/jidawanghao/article/details/108867540