Exporting to Excel

[Nirmal]

i am trying to Export the data to excel

list = [{'ip': u'9.11.180.3','endpoint': u'rd2ff5-az2-1519-1520_eth1-18_vpc', 'hostname': u'RD2APIC1', 'encap': u'vlan-42', 'epg': u'19_14_140_172', 'extpaths': u'topology/pod-2/protpaths-1519-1520/pathep-[rd2ff5-az2-1519-1520_eth1-18_vpc]'},{'ip': u'14.10.5.5','endpoint': u'eth1/2','hostname': u'RD2APIC1', 'encap': u'vlan-18', 'epg': u'14_70_7_0', 'extpaths': u'topology/pod-2/paths-1511/extpaths-102/pathep-[eth1/2]'}]

My Code :

filename = self.controller + ".xls"
        excel_file = xlwt.Workbook()
        sheet = excel_file.add_sheet('HOSTLIST')
        sheet.write(0, 0, "APIC")            
        sheet.write(0, 1, "VLAN")
        sheet.write(0, 2, "EPG")
        sheet.write(0, 3, "EndPoint")
        sheet.write(0, 4, "Extpath")
        for count in xrange(1, len(list) + 1):
            if list[count - 1]["epg"]:
                epg = list[count - 1]["epg"]
            else:
                epg = "UNKNOWN"

            sheet.write(count, 0, list[count - 1].get("hostname","UNKNOWN"))
            sheet.write(count, 1, list[count - 1].get("encap","UNKNOWN"))
            sheet.write(count, 2, epg)
            sheet.write(count, 3, list[count - 1].get("endpoint","UNKNOWN"))
            sheet.write(count, 4, list[count - 1].get("extpaths","UNKNOWN"))
        excel_file.save(filename)

[/python]

Link Below : Current and Expected Output :



I have uploaded the image , its about current and expected output . Basically i need to split the "endpoint" if it starts with "rd" while exporting it to excel.

in this case "endpoint - rd2ff5-az2-1519-1520_eth1-18_vpc" needs to be splited as rd2ff5-az2-1519 and rd2ff5-az2-1520 in two rows inserted instead of one in the excel sheet.

Any suggestion/idea ?