I’m looking for Ansible module for file conversion from excel to json.
I cannot go with Python script, since I had to install pandas, openpyxl packages/ modules to convert files. Since we have Ansible implemented, I would like to know whether there is any Ansible module that converts Excel file to Json format.
Any help would be greatly appreciated. Thank you.
If there is a module for conversion from Excel to JSON it will likely require installation of one of the Python libraries you mention.
It’s not unsusual for a module or a plugin to require additional software: the
git module requires the Git system package, and the
dig lookup plugin, say, requires
So, if you have the knowhow to create such a module, have at it!
Exporting from Excel as csv and then using the community.general.read_csv module might be an option?