# example.py
from openpyxl import Workbook
wb = Workbook()
# grab the active worksheet
ws = wb.active
# Data can be assigned directly to cells
ws['A1'] = 42
# Rows can also be appended
ws.append([1, 2, 3])
# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()
# Save the file
wb.save("sample.xlsx")
# table.py
fro openpyxl import Workbook
from openpyxl.worksheet.table import Table, TableStyleInfo
wb = Workbook()
ws = wb.active
data = [
['Apples', 10000, 5000, 8000, 6000],
['Pears', 2000, 3000, 4000, 5000],
['Bananas', 6000, 6000, 6500, 6000],
['Oranges', 500, 300, 200, 700],
]
# add column headings. NB. these must be strings
ws.append(["Fruit", "2011", "2012", "2013", "2014"])
for row in data:
ws.append(row)
tab = Table(displayName="Table1", ref="A1:E5")
# Add a default style with striped rows and banded columns
style = TableStyleInfo(name="TableStyleMedium9", showFirstColumn=False,
showLastColumn=False, showRowStripes=True, showColumnStripes=True)
tab.tableStyleInfo = style
ws.add_table(tab)
wb.save("table.xlsx")
看了上面两个案例之后是不是感觉好容易理解?
不清楚你是怎么感觉得,反正我是觉得so easy!(好后悔当初没有好好学英语有木有)。这个是openpyxl的源码介绍,今天看了它的源码啥的,突然感觉博客啥的都好low。而且里面个讲的有仔细,有些命名还特别有趣。
学习东西还是直接看官方说明文档比较好(也可以看源码),而且版本比较新,别人的编程风格也好。能学到的东西特别多。
以后还是多看源码学习比较好,百度博客绝大多数都没这个简单易懂而且系统性强。