Python3匯出xls檔案工具
- 安裝匯出檔案所需依賴包：如果安裝比較慢可以參考之前文章更換下載源即可
pip3 install xlwt - 示例
""" @Author : @Time : 2020/12/25 12:39 @Function: 匯出xls檔案工具 """ import xlwt from io import BytesIO from django.http import HttpResponse def down_load_logger_tools(header, data_list): """ header = [] data_list = [[], []] """ # http連接方式 response = HttpResponse(content_type='application/vnd.ms-excel') # filename xls檔案名 response['Content-Disposition'] = 'attachment;filename=logging.xls' # 編碼格式 wb = xlwt.Workbook(encoding='utf-8') # sheet名 sheet = wb.add_sheet('操作日志記錄表') # 設定xls檔案表頭顏色 pattern = xlwt.Pattern() pattern.pattern = xlwt.Pattern.SOLID_PATTERN pattern.pattern_fore_colour = 5 style = xlwt.XFStyle() style.pattern = pattern # 匯出excel表頭 if header: for number, value in enumerate(header): sheet.write(0, number, value, style) else: return HttpResponse('header為空，匯出xls檔案失敗') # 匯出excel資料 if data_list: _excel_row = 1 for k, v in enumerate(data_list): for i, j in enumerate(v): # 行 列 值 sheet.write(_excel_row, i, j) _excel_row += 1 # 寫出到IO output = BytesIO() wb.save(output) # 重新定位到開始 output.seek(0) response.write(output.getvalue()) return response else: return HttpResponse('匯出xls檔案失敗') if __name__ == '__main__': header = ['name', 'age'] data_list = [['小王', '24'], ['小李', '25']] down_load_logger_tools(header=header, data_list=data_list)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/241011.html
標籤：python
上一篇：CSDN開發者周刊第 22期：谷歌 DeepMind 第四代：不學規則就可以玩游戲；圖靈獎得主 Edmund Clarke 因感染“新冠”逝世；