ansible playbook - define data in excel sheets

18 views
Skip to first unread message

stack flow

unread,
Jul 11, 2020, 10:43:19 PM7/11/20
to Ansible Project
I have excel file data.xslx and it has two sheets:

sheet1:

HostnameMgmt_ip
Switch-110.0.0.1
Switch-210.0.0.2
Switch-310.0.0.3


sheet2:

InterfaceInterface_IPDescription
Ethernet1/1192.168.100.1/30To Spine-1
Ethernet1/2192.168.100.5/30To 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.



stack flow

unread,
Jul 12, 2020, 11:00:28 AM7/12/20
to Ansible Project
some help please.

Antony Stone

unread,
Jul 12, 2020, 2:37:15 PM7/12/20
to ansible...@googlegroups.com
On Sunday 12 July 2020 at 17:00:27, stack flow wrote:

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

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


Antony,

--
This sentence contains exacly three erors.

Please reply to the list;
please *don't* CC me.
Reply all
Reply to author
Forward
0 new messages