data = [] for row in sheet.iter_rows(): data.append([cell.value for cell in row])
def all_rows(sheet): for row in sheet.iter_rows(): yield [cell.value for cell in row]
for row in all_rows(sheet): print(row)
上一篇:遍历所有行并取消合并单元格的openpyxl代码。
下一篇:遍历所有XML元素和属性的最佳方法