from openpyxl import load_workbook

 from openpyxl import load_workbook

 wb = load_workbook(filename=r'C:\\Users\\Administrator\\Desktop\\库存大表0803.xlsx')  ##读取路径

 ws = wb.get_sheet_by_name("Sheet1")  ##读取名字为Sheet1的sheet表

 num = 1

 while 1:

     cell = ws.cell(row=num, column=1).value

     if cell:

         num = num +1

     else:

         print(num)

         exit()

while 1:

cell = ws.cell(row=num, column=1).value

if cell:

    num = num +1

else:

    print(num)

    exit()