import openpyxl
from openpyxl.utils import FORMULAE
from openpyxl.drawing.image import Image
# 检查公式是否存在
# print('SUM' in FORMULAE)
wb = openpyxl.Workbook()
ws1 = wb.active
# SUM函数使用
ws1['A1'] = 100
ws1['A2'] = 200
ws1['A3'] = '=A1+A2'
ws1['A4'] = '=sum(A1:A3)'
# 单元格:合并
ws1.merge_cells('B1:B4')
ws1.merge_cells('B5:B6')
# 单元格拆分
ws1.unmerge_cells('B5:B6')
2020年3月17日08:54:34文档写到插入图像
wb.save('函数基本.xlsx')