Simple example on how to write to excel

Openpyxl write file

        wb = Workbook()
        sheet = wb.create_sheet()
        row = 1
        col = 1
        for header in headers:
            sheet.cell(row=row, column=col, value=header)
            col += 1
        row += 1
        git_lines = self.report(git_format)
        for line in git_lines:
            self.stdout.write(line)
            line_data = line.split('|')
            col = 1
            for data in line_data:
                sheet.cell(row=row, column=col, value=data)
                col += 1
            row += 1

        wb.save(filename)