Python-Excel-win32com-10-最大行最大列

import os
import win32com
from win32com.client import constants as c  # 旨在直接使用VBA常数
current_address = os.path.abspath('.')
upper_address = os.path.dirname(current_address)

excel_address = os.path.join(upper_address, "最大行最大列.xlsx")
print(excel_address)
xl_app = win32com.client.gencache.EnsureDispatch("Excel.Application")  # 若想引用常数的话使用此法调用Excel
xl_app.Visible = True  # 是否显示Excel文件
wb = xl_app.Workbooks.Open(excel_address)
sht = wb.Worksheets(1)

range_used = sht.UsedRange
max_row = range_used.Rows.Count
max_col = range_used.Columns.Count

print("最大行：", max_row)
print("最大列：", max_col)

wb.Close()
xl_app.Quit()

range_used = sht.Cells
max_row = range_used.Rows.Count
max_col = range_used.Columns.Count

range_used = sht.Range("A3:C5")
max_row = range_used.Rows.Count
max_col = range_used.Columns.Count