excel (multiple sheets) to yml file for each sheet

[stack flow]

Hi,

I have excel file with multiple sheets and need output as yml file for each sheet. could someone help me with python code? following is an example:

aep sheet:

aep        aep_description     infra_vlan
test_AEP      test aep            no

aeps_to_domain sheet:

aep	          domain	domain_type
test_AEP	test_PHY_DOM	phys
test1_AEP	test1_PHY_DOM	l3dom


scription should output two files:

aeps-vars.yml:

aeps:
  - aep: test_AEP
    aep_description: test aep
    infra_vlan: no


aeps_to_domain-vars.yml:

aeps_to_domain:
  - aep: test_AEP
    domain: test_PHY_DOM
    domain_type: phys  
  - aep: test_AEP
    domain: test_L3O_DOM
    domain_type: l3dom