def write_items()

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()