excel (multiple sheets) to yml file for each sheet
stack flow
stackflowauto at gmail.com
Fri Jul 17 20:04:08 EDT 2020
help please.
On Thursday, July 16, 2020 at 10:38:23 PM UTC-4, stack flow wrote:
> 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