(self, items:QueryResult)
| 95 | return file_name |
| 96 | |
| 97 | def convert_to_csv(self, items:QueryResult) -> str: |
| 98 | try: |
| 99 | self._create_directory(self._output_dir) |
| 100 | file_name = os.path.join(self._output_dir, Hashing.get_md5(''.join([str(i.criterial) for i in items])))+".xlsx" |
| 101 | wb = Workbook() |
| 102 | for index, result in enumerate(items): |
| 103 | ws = None |
| 104 | if index == 0: |
| 105 | ws = wb.active |
| 106 | ws.title = result.value |
| 107 | else: |
| 108 | ws = wb.create_sheet(result.value) |
| 109 | |
| 110 | for col, h in enumerate(result.results.headers, start=1): |
| 111 | ws.cell(row=1, column=col, value=h) |
| 112 | |
| 113 | for row_idx,row_data in enumerate(result.results.rows, start=2): |
| 114 | for col_idx, value in enumerate(row_data, start=1): |
| 115 | ws.cell(row=row_idx, column=col_idx, value=value) |
| 116 | |
| 117 | wb.save(file_name) |
| 118 | return file_name |
| 119 | except Exception as e: |
| 120 | AnsiPrint.print_debug(e) |
| 121 | |
| 122 | def save_content(self, items:list[Result]) -> str: |
| 123 | explorer_folder = ResultSetting().get_folder_output('html') |
no test coverage detected