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