excel.py 文件源码

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