python 如何处理excel文件

from openpyxl import Workbook, load_workbook
from openpyxl.styles import Font, colors, Alignment

a = Workbook()  # 整个excel文件
part1 = a.active  # 第一页
part1.title = "The one"
part1["B1"] = 12255
part1["C1"] = "干啊"
part1.append([0,1,2,"dasdsa"])

a.save("tang1.xlsx")

# 打开文件
b = load_workbook("tang1.xlsx")
print(b.sheetnames)  # 返回sheet名称
print(b['登记表']['B11'].value)  # 取出登记表这页B11的数据
for i in b['登记表']['B11:H11']:
    print(i)  # i是一个元组,所以还需要进一步拿这个数据
    for x in i:
        print(x.value)

# 按行遍历
for row in b['登记表']:
    # print(row)
    for i in row:
        print(i.value, end=",")  # 遍历不换行
    print()  # 遍历下一行时先换行

# 按列循环
for column in b['登记表'].columns:
    for i in column:
        print(i.value,end=",")
    print()

# 指定行+列
for row in b['登记表'].iter_rows(min_row=10,max_row=15,max_col=6):
    for i in row:
        print(i.value,end=",")
    print()

#  指定列+行
for col in b['登记表'].iter_cols(min_col=1,max_col=6,min_row=9,max_row=15):
    for i in col:
        print(i.value,end=",")
    print()

# 删除工作表
b.remove(b['Sheet1'])
del b["Sheet"]

# 给excel添加样式
s1 = Font(name="宋体", size=10, italic=True, color='FF000000', bold=True)
b['The one']['D1'] = '你看什么看'
b['The one']['D1'].font = s1
b['The one']['D1'].alignment = Alignment(vertical="center", horizontal="center")  # 垂直居中，水平居中
b['The one'].row_dimensions[1].height = 30  # 改变行高
b['The one'].column_dimensions['B'].width = 40  # 改变列宽
b.save('tang1.xlsx')