excel (multiple sheets) to yml file for each sheet

2020-07-16 Thread stack flow
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:

aepaep_description infra_vlan
test_AEP  test aepno

aeps_to_domain sheet:

aep   domaindomain_type
test_AEPtest_PHY_DOMphys
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


Re: excel (multiple sheets) to yml file for each sheet

2020-07-17 Thread 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:
> 
> aepaep_description infra_vlan
> test_AEP  test aepno
> 
> aeps_to_domain sheet:
> 
> aep domaindomain_type
> test_AEP  test_PHY_DOMphys
> 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