excel (multiple sheets) to yml file for each sheet

[stack flow]

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