1 # xlsxwtiter
2 try:
3 output = BytesIO()
4 wb = xlsxwriter.Workbook(output)
5 sheet = wb.add_worksheet('audit-sheet')
6 head_cell_xf = wb.add_format({
7 'font_name': 'SimSun',
8 'bold': True,
9 'text_wrap': True,
10 'valign': 'vcenter',
11 'align': 'left',
12 'bg_color': 'red',
13 'pattern': 1,
14 'bottom': 1,
15 'left': 1,
16 'right': 1,
17 'top': 1,
18 })
19
20 body_cell_xf = wb.add_format({
21 'font_name': 'SimSun',
22 'valign': 'vcenter',
23 'align': 'left',
24
25 'bg_color': 'gray',
26 'pattern': 1,
27 'bottom': 1,
28 'left': 1,
29 'right': 1,
30 'top': 1,
31 })
32
33 head_data = ['帐号名', '操作模块', '操作时间', '操作类型', '请求url', '请求方法', '请求结果', '请求描述', '请求内容']
34 sheet.write_row('A1', head_data, head_cell_xf)
35 data_row = 2
36 rsp_data = json.loads(rsp.content)['result']["audits"]
37 for item in rsp_data:
38 temp = []
39 action_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(item.get("action_timestamp", "")))
40 temp.append(item.get("account_name", ""))
41 temp.append(item.get("action_module", ""))
42 temp.append(action_time)
43
44 temp.append(item.get("action_type", ""))
45 temp.append(item.get("action_url", ""))
46 temp.append(item.get("action_method", ""))
47 temp.append(item.get("action_result", ""))
48 temp.append(item.get("action_summary", ""))
49 temp.append(item.get("action_content", ""))
50 sheet.write_row('A' + str(data_row), temp, body_cell_xf)
51 data_row += 1
52
53 wb.close()
54
55 response = HttpResponse(output.getvalue())
56 response['content_type'] = 'application/vnd.ms-excel'
57 response['Content-Disposition'] = 'attachment;filename=audit.xls'
58 response.write(output.getvalue())
59 return response
60
61 except Exception as e:
62 LOG.error("导出execl失败 %s" % e)
63 return Response({"status": rsp.status, "message": "导出execl失败", "result": {}, "module": "audit"})
64
65
66 # xlwt
67 try:
68 style_heading = xlwt.easyxf("""
69 font:
70 name Arial,
71 colour_index white,
72 bold on,
73 height 0xA0;
74 align:
75 wrap off,
76 vert center,
77 horiz center;
78 pattern:
79 pattern solid,
80 fore-colour 0x19;
81 borders:
82 left THIN,
83 right THIN,
84 top THIN,
85 bottom THIN;
86 """)
87
88 wb = xlwt.Workbook(encoding='utf8')
89 sheet = wb.add_sheet('audit-sheet')
90 sheet.write(0, 0, '帐号名', style_heading)
91 sheet.write(0, 1, '操作模块', style_heading)
92 sheet.write(0, 2, '操作时间', style_heading)
93 sheet.write(0, 3, '操作类型', style_heading)
94 sheet.write(0, 4, '请求url', style_heading)
95 sheet.write(0, 5, '请求方法', style_heading)
96 sheet.write(0, 6, '请求结果', style_heading)
97 sheet.write(0, 7, '请求描述', style_heading)
98 sheet.write(0, 8, '请求内容', style_heading)
99
100 data_row = 1
101 rsp_data = json.loads(rsp.content)['result']["audits"]
102 for item in rsp_data:
103 action_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(item.get("action_timestamp", "")))
104 sheet.write(data_row, 0, item.get("account_name", ""))
105 sheet.write(data_row, 1, item.get("action_module", ""))
106 sheet.write(data_row, 2, action_time)
107 sheet.write(data_row, 3, item.get("action_type", ""))
108 sheet.write(data_row, 4, item.get("action_url", ""))
109 sheet.write(data_row, 5, item.get("action_method", ""))
110 sheet.write(data_row, 6, item.get("action_result", ""))
111 sheet.write(data_row, 7, item.get("action_summary", ""))
112 sheet.write(data_row, 8, item.get("action_content",""))
113 data_row += 1
114
115 output = BytesIO()
116 wb.save(output)
117 output.seek(0)
118 response = HttpResponse(output.getvalue())
119 response['content_type'] = 'application/vnd.ms-excel'
120 response['Content-Disposition'] = 'attachment;filename=audit.xlsx'
121 response.write(output.getvalue())
122 return response
123 except Exception as e:
124 LOG.error("导出execl失败 %s" % e)
125 return Response({"status": rsp.status, "message": "导出execl失败", "result": {}, "module": "audit"})
