excel (multiple sheets) to yml file for each sheet
stack flow
stackflowauto at gmail.com
Thu Jul 16 22:38:09 EDT 2020
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
More information about the Python-list
mailing list