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

-- 
https://mail.python.org/mailman/listinfo/python-list

Reply via email to