#!/usr/bin/env python

 import xlwt,xlrd,datetime,json,os,xlutils.copy

 a={

     'VpcPeeringConnection': {

         'AccepterVpcInfo': {

             'CidrBlock': 'abc',

             'Ipv6CidrBlockSet': [

                 {

                     'Ipv6CidrBlock': 'qwe'

                 },

             ],

             'CidrBlockSet': [

                 {

                     'CidrBlock': 'qwrqrqrwrqr'

                 },

             ],

             'OwnerId': '123asf',

             'PeeringOptions': {

                 'AllowDnsResolutionFromRemoteVpc': True,

                 'AllowEgressFromLocalClassicLinkToRemoteVpc': True,

                 'AllowEgressFromLocalVpcToRemoteClassicLink': True

             },

             'VpcId': 'asdfghjk',

             'Region': ';lkjhg'

         },

         'ExpirationTime': "aaaa",

         'RequesterVpcInfo': {

             'CidrBlock': '12qwesd',

             'Ipv6CidrBlockSet': [

                 {

                     'Ipv6CidrBlock': 'mjhngb'

                 },

             ],

             'CidrBlockSet': [

                 {

                     'CidrBlock': 'oikujhg'

                 },

             ],

             'OwnerId': 'lkjh',

             'PeeringOptions': {

                 'AllowDnsResolutionFromRemoteVpc': True,

                 'AllowEgressFromLocalClassicLinkToRemoteVpc': True,

                 'AllowEgressFromLocalVpcToRemoteClassicLink': True

             },

             'VpcId': 'waqsd',

             'Region': 'awsd'

         },

         'Status': {

             'Code': "'initiating-request'",

             'Message': 'lk_mjhn'

         },

         'Tags': [

             {

                 'Key': 'mhngbv',

                 'Value': 'gfd'

             },

         ],

         'VpcPeeringConnectionId': 'ytgrf'

     }

 }

 #os.remove('./bcd111.xls')

 def write_excel(filename,dic):

     sh = xlwt.Workbook()

     sheet1 = sh.add_sheet('table123')

     sheet1.write(0,0,"CidrBlock")

     sheet1.write(0,1,"Ipv6CidrBlock")

     sheet1.write(0,2,'OwnerId')

     sheet1.write(0, 3, 'VpcId')

     dic_key = dic.keys()

     temp =1

     for key_names in dic_key:

         key_name = a[key_names].keys()

         for names in key_name:

             if isinstance(a[key_names][names],dict):

                 if 'CidrBlock' in dic[key_names][names].keys() or 'Ipv6CidrBlock' in dic[key_names][names].keys() or 'OwnerId' in dic[key_names][names].keys() or 'VpcId' in dic[key_names][names].keys() :

                     sheet1.write(temp,0,dic[key_names][names].get('CidrBlock',''))

                     sheet1.write(temp, 1, dic[key_names][names].get('Ipv6CidrBlock',''))

                     sheet1.write(temp, 2, str(dic[key_names][names].get('OwnerId', '')))

                     sheet1.write(temp, 3, dic[key_names][names].get('VpcId', ''))

                     temp = temp+1

     sh.save(filename)

 write_excel('bcd111.xls',a)