def export_to_xlsx(table, headers=None, title="Exported table", file_name=None):
"""
Create a simple Excel workbook from the given table and optional headers.
"""
assert_is_two_dimensional_list(table)
# XXX https://bitbucket.org/openpyxl/openpyxl/issue/375/use-save_virtual_workbook-and-optimized
wb = Workbook(write_only=False)
ws = wb.active
ws.title = title
if (headers is not None):
assert (len(table) == 0) or (len(headers) == len(table[0]))
ws.append(headers)
for row in table:
ws.append(row)
if (file_name is None):
return save_virtual_workbook(wb)
else:
wb.save(file_name)
return file_name
评论列表
文章目录