【python】Excel文件读写-初识openpyxl库

filename = 'test_Case001.xlsx'

# 打开表
workbook = load_workbook(filename)

# 获取excel中所有sheet名
worksheet_list = workbook.sheetnames

# 根据sheet索引 定位表单
worksheet_by_index = workbook.worksheets[0]

# 根据sheet名 定位表单
worksheet_by_name = workbook[worksheet_list[0]]

# 获取单元格的值 cell(row，column)
cell_value = worksheet_by_index.cell(1, 2).value

# 获取sheet的最大列数
sheet_max_column = worksheet_by_index.max_column

# 获取sheet的最大行数
sheet_max_row = worksheet_by_index.max_row

# 修改单元格cell的值
worksheet_by_index.cell(1, 2).value = 'excel回写'

# 保存对excel的修改
workbook.save(filename)