tablib¶
示例¶
生成单张工作簿, headers 为表头, title 为工作簿名¶
data为数据列表,里面是一行行内容
tablib.Dataset(*data, headers=headers, title=sheet_name)
写 xlsx¶
# tmp_data 为一个字典, 字典的 value 是dataset
book = tablib.Databook(tuple(tmp_data.values()))
with open(filename, 'wb') as f:
f.write(book.xlsx)
# 添加排序
book = tablib.Databook(tuple(tmp_data[key] for key in sorted(tmp_data.keys())))
with open(filename, 'wb') as f:
f.write(book.xlsx)