Excel.Application python 获取总行数 操作excel 获取总列数

import win32com.client, time


xlApp = win32com.client.DispatchEx("Excel.Application")
xlApp.Visible = True
xlApp.DisplayAlerts = 0
# 宏所在的xls
xlApp.Workbooks.Open(r"D:\code\maria_po_transfer\1.xls", False)
worksheet = xlApp.ActiveSheet

#获取总行数
row_count = worksheet.UsedRange.Rows.Count
print(row_count)

col_count = worksheet.UsedRange.Columns.Count
print(col_count)

for i in range(7, i + 1):
    j = worksheet.Range("b"+ str(i)).Value
    j = str(int(j))
    print(j)

xlApp.quit()

参考
https://stackoverflow.com/questions/33824433/get-excel-row-number-via-ms-excel