学习代码,仅供参考
# 读取excel文件并输出内容
import openpyxl as xl
import datetime
from openpyxl.chart import BarChart, Reference
from openpyxl.styles import PatternFill, Font
# 打开excel文件,获取工作簿对象
wb = xl.load_workbook("example.xlsx")
# 从工作薄中获取一个表单(sheet)对象
sheets = wb.sheetnames
# 打印工作项
print(sheets, type(sheets))
# 获取激活工作项对象
ws = wb.active
# 激活项设置值
ws['A1'] = 1
# 写入一个自定义的时间格式
ws['A2'] = datetime.datetime.now().strftime("%Y-%m-%d")
ws['A3'] = datetime.datetime.now()
# 设置样式给单元格
ft = Font(name=u'微软雅黑', size=11, bold=False, italic=False, vertAlign=None, underline='none', strike=False, color='FF000000')
fill = PatternFill(fill_type="solid", start_color='FFEEFFFF', end_color='FF001100')
ws["A1"].font = ft
ws["A2"].fill = fill
# 创建一个表单
sheet5 = wb.create_sheet('sheet4')
# 画一个柱状图
for i in range(9):
ws.append([i])
values = Reference(ws, min_col=1, min_row=1, max_col=1, max_row=9)
chart = BarChart()
chart.add_data(values)
ws.add_chart(chart, "A15")
# 保存上述修改
wb.save("example.xlsx")