python 使用 openpyxl 的用法(二)

删除行和列 .delete_rows()和.delete_cols()

from openpyxl import load_workbook

workbook = load_workbook('../data/4.1test.xlsx')

sheet = workbook.active

# 删除第二列
sheet.delete_cols(idx=2, amount=1)

# 从第三行开始删除两行
sheet.delete_rows(idx=3, amount=2)

workbook.save('../data/4.1test.xlsx')

创建新的 sheet 表格 .create_sheet()

from openpyxl import load_workbook

workbook = load_workbook('../data/5.1test.xlsx')

sheet = workbook.active

print(workbook.sheetnames)

workbook.create_sheet('newSheet')

print(workbook.sheetnames)

workbook.save('../data/5.1test.xlsx')

删除某个 sheet 表 .remove()

from openpyxl import load_workbook

workbook = load_workbook('../data/6.1test.xlsx')

sheet = workbook.active

print(workbook.sheetnames)

for item in workbook.sheetnames[1:]:
    # 这个操作相当于激活的这个要删除的 sheet 表，激活状态下，才可以操作；
    remove_sheet = workbook[item]
    # 删除某个sheet 表
    workbook.remove(remove_sheet)

print(workbook.sheetnames)

workbook.save('../data/6.1test.xlsx')

复制一个 sheet 表 .copy_worksheet()

from openpyxl import load_workbook

workbook = load_workbook('../data/7.1test.xlsx')

print(workbook.sheetnames)

sheet = workbook.active

workbook.copy_worksheet(sheet)

print(workbook.sheetnames)


workbook.save('../data/7.1test.xlsx')

写在最后

入门使用就这些，更高深的用法在实践中去发现吧。。。