samples.py 文件源码

def make_xlsx(rows):
    tmp_path = tempfile.mktemp()
    workbook = xlsxwriter.Workbook(tmp_path, {'strings_to_numbers': False,
                                              'strings_to_formulas': False,
                                              'strings_to_urls': False})
    worksheet = workbook.add_worksheet()
    worksheet.write_row(0, 0, rows.headers)
    for i, row in enumerate(rows):
        worksheet.write_row(i + 1, 0, row)
    workbook.close()
    contents = open(tmp_path, "rb").read()
    os.remove(tmp_path)
    return contents