ansible playbook - define data in excel sheets

Archives Ansible Project
1

I have excel file data.xslx and it has two sheets:

sheet1:

Hostname | Mgmt_ip |

  • | - |
    Switch-1 | 10.0.0.1 |
    Switch-2 | 10.0.0.2 |
    Switch-3 | 10.0.0.3 |

sheet2:

Interface | Interface_IP | Description |

  • | - | - |
    Ethernet1/1 | 192.168.100.1/30 | To Spine-1 |
    Ethernet1/2 | 192.168.100.5/30 | To Spine-2
    |

how to write yml to read data from each of the sheet of xlsx. I am unable to find ansible module for this.

2

some help please.

3

I suggest you investigate https://linux.die.net/man/1/ssconvert.

Antony,