Write to Excel file in the control machine

Hello guys,

Could you please suggest what would be the best approach to create an excel file in control node of the provided hostnames in the ansible playbook command.

Thanks
Pradyumna

Hello Pradyumna,
I have below playbook where i generate files in csv format for vmware inventory. please check if this kind or report you are looking, you can customise this according to your requirements.
playbook on this github link.
https://github.com/area51coder/ansible_group_issues/tree/main/vmware_csvreport

Regards
Ravi
yoursmartbook.blogspot.com

Hi Ravi,

Thank you for your kind reply.
I am running the ansible playbook. anisible_hostname var contains the hostname which needs to be updated in the excel sheet. Kindly find the attached excel file in JPEG format.
The hostname are in the excel B,C,L,S column. Hostname are 1ld619 and 1ld620.
Please suggest.

Regards
Prady

(attachments)