in src/advisor/reports/dependencies_report.py [0:0]
def write_items(self, output_file, items):
workbook = xlsxwriter.Workbook(output_file)
classified = {}
for item in items:
if item.tool not in classified:
classified[item.tool] = [item]
else:
classified[item.tool].append(item)
for tool in classified:
worksheet = workbook.add_worksheet(tool)
self._write_header(worksheet)
dependencies = classified[tool]
row = 1
for dependency in dependencies:
if dependency.version:
version = dependency.version
else:
version = 'LATEST'
row_to_write = [dependency.name, version, dependency.tool, dependency.filename]
col = 0
for column in row_to_write:
worksheet.write(row, col, column)
col += 1
row += 1
workbook.close()