xlsxwriter - Remove Duplicate Items in odoo Looping

Question

Hy , I want to print odoo in XLSX, this is my code:

    def generate_xlsx_report(self, workbook, data, lines):
    format = workbook.add_format({'font_size' : 12, 'align': 'center', 'bold' : True})
    format1 = workbook.add_format({'font_size': 12, 'align': 'center', 'bold': False})
    sheet = workbook.add_worksheet("Assets")
    sheet.set_row(0, 24)
    sheet.set_column('A1:O1', 20)
    headers = [
        "No",
        "Asset Name",
        "Category",
        "Date",
        "Partners",
        "Gros Value",
        "Residual Value",
        "Value",
        "Number Of Depreciations",
        "Number of Month in a Period"
        "Depre Date",
    ]

    column = 0
    row = 0
    for col in headers:
        sheet.write(row, column, col, format)
        column += 1

    row = 1
    final_data = []
    no = 1
    for data in lines:
            for datas in data:
                for depre in datas.depreciation_line_ids:
                    final_data.append([
                    no,
                    datas.name,
                    datas.category_id.name,
                    datas.date.strftime("%Y-%m-%d"),
                    "Maju mundur",
                    datas.value,
                    datas.salvage_value,
                    datas.value_residual,
                    datas.method_number,
                    datas.method_period,
                    depre.depreciation_date.strftime("%Y-%m-%d"),
                    ])
                    no += 1

    for data in final_data:
        column = 0
        for col in data:
            sheet.write(row, column, col,format1)
            column += 1
        row += 1

    workbook.close()

And this is my expecation output

Each assets have many depreciation, but when I print assets, output like below :

How to just return each assets ( no duplicate) , look , Asset Name, Category and Date is duplicate data, even tough is just 1 data , how to print output each assets and have many depreciation date?
Thanks

question from:https://stackoverflow.com/questions/65680359/remove-duplicate-items-in-odoo-looping

Answer 1

Waitting for answers