28 lines
915 B
Python
28 lines
915 B
Python
import xlsxwriter
|
|
import os
|
|
|
|
|
|
def generate_report_excel(output, filename):
|
|
if os.path.exists(filename):
|
|
os.remove(filename)
|
|
workbook = xlsxwriter.Workbook(filename)
|
|
bold = workbook.add_format({'bold': 1})
|
|
for server in range(len(output)):
|
|
worksheet = workbook.add_worksheet(output[server]['name'])
|
|
worksheet.set_column('A:A', 40)
|
|
worksheet.set_column('B:B', 15)
|
|
worksheet.write('A1', 'Components', bold)
|
|
worksheet.write('B1', 'Status', bold)
|
|
row = 1
|
|
col = 0
|
|
for key, value in list(output[server]['result'].items()):
|
|
worksheet.write_string(row, col, key)
|
|
if value == 0:
|
|
status = 'OK'
|
|
else:
|
|
status = 'Error'
|
|
worksheet.write_string(row, col + 1, key)
|
|
worksheet.write_string(row, col + 1, status)
|
|
row += 1
|
|
workbook.close()
|