Python创建、读取、修改Excel单元格内容

from openpyxl import Workbook
from openpyxl import load_workbook

if __name__ == '__main__':
    #创建Excel对象
    wb = Workbook()
    file_name = 'test.xlsx'

    #创建第一张表格
    ws1 = wb.active
    ws1.title = "test_sheet_1"
    #填写表格内容
    for row in range(1, 6):
        ws1.append(range(8))

    #创建第二张表格
    ws2 = wb.create_sheet(title="test_sheet_2")
    ws2['C3'] = 666

    #保存Excel文件
    wb.save(filename=file_name)

    #读取Excel内容
    wb = load_workbook(filename=file_name)
    sheet = wb['test_sheet_1']
    print(sheet['D1'].value)

    #修改Excel内容
    sheet['A5'] = 888
    wb.save(filename=file_name)