from openpyxl import load_workbook

#只能加载已存在的表格

wb=load_workbook("D:\zhijing_work\测试数据\测试文件\yetangjian.xlsx")

sheet=wb['Sheet1']

# 操作单列

for cell in sheet["B"]:

    print(cell.value)

#操作多列

for column in sheet["A:C"]:

    for cell in column:

        print(cell.value)

# 操作多行

for row in sheet[1:3]:

    for cell in row:

        print(cell.value)

# 写入内容后保存

cell=sheet["B5"]

cell.value="写入"

wb.save("D:\zhijing_work\测试数据\测试文件\yetangjian.xlsx")

# 追加插入数据

data=[11,11,22,33,44,55,66,77]

sheet.append(data)

wb.save("D:\zhijing_work\测试数据\测试文件\yetangjian.xlsx")