读单元格

from openpyxl import load_workbook
wb = load_workbook("files/p1.xlsx")
sheet = wb.worksheets[0]
# 获取第几行第几列
cell = sheet.cell(1,1)
# 获取值
print(cell.value)
# 获取样式
print(cell.style)
# 获取字体
print(cell.font)
# 获取排列情况
print(cell.alignment)
# 获取某个单元格
c1 = sheet["A2"]
print(c1.value)
# 获取第一行所有单元格的内容
for cell in sheet[1]:
    print(cell.value)
# 获取所有行的数据
for row in sheet.rows:
    print(row[0].value,row[1].value)
# 获取所有列的数据
for col in sheet.columns:
    print(col[1].value)