python - 在 Openpyxl 中跳过第一行

Question

嗨，我有以下代码

wb_obj = openpyxl.load_workbook(path, data_only=True) 
worksheet = wb_obj.get_sheet_by_name('Sheet1')

for row_cells in worksheet.iter_rows():
    for cell in row_cells:
       print('%s: cell.value=%s' % (cell, cell.value) )

它运作良好。但是我不需要它来显示来自标题行的第一行的数据。如何更改查询以排除第一行？

Answer 1

documentation建议使用 iter_rows

for row_cells in worksheet.iter_rows(min_row=2):
    for cell in row_cells:
        print('%s: cell.value=%s' % (cell, cell.value) )