openpyxl 按行读取excel
from openpyxl import load_workbook
# 打开文件
wb = load_workbook('students.xlsx')
# 选择第一个sheet
sheet = wb.active
# 遍历每一行
for i in sheet.iter_rows():
for c in i:
print(c.value,end='\t') # 按单元格读取
print('\n')
openpyxl 按行读取excel
from openpyxl import load_workbook
# 打开文件
wb = load_workbook('students.xlsx')
# 选择第一个sheet
sheet = wb.active
# 遍历每一行
for i in sheet.iter_rows():
for c in i:
print(c.value,end='\t') # 按单元格读取
print('\n')