excel.py 文件源码

python
阅读 27 收藏 0 点赞 0 评论 0

项目:edd 作者: JBEI 项目源码 文件源码
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
评论列表
文章目录


问题


面经


文章

微信
公众号

扫码关注公众号