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
-- 
https://mail.python.org/mailman/listinfo/python-list

Reply via email to