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[i]) print(sheet.title + ': max_row: ' + str(sheet.max_row) + ' max_column: ' + str(sheet.max_column))
python_excel_openpyxl_遍历sheet工作表名
最新推荐文章于 2024-07-22 03:29:33 发布