python读取execl表格

from openpyxl import  load_workbook
workbook = load_workbook(r'../case/case.xlsx')
sheets = workbook['sheet1']
rows_sheet = sheets.iter_rows() #返回一个迭代器

for item in rows_sheet:
    #跳过标题行
    if item[0].value == 'url':
        continue

    list = []
    #逐行读取
    for col in item:
        list.append(col.value)