mamullen13316 / ansible_xls_to_facts Goto Github PK

Hi Matt,

Thank you for your module.

I followed the steps provided in the READ.me and Python files but unfortunately, I am getting the following error:

localhost | FAILED! => {
"changed": false,
"failed": true,
"module_stderr": "OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013\r\ndebug1: Reading configuration data /etc/ssh/ssh_config\r\ndebug1: /etc/ssh/ssh_config line 56: Applying options for *\r\ndebug1: auto-mux: Trying existing master\r\ndebug2: fd 3 setting O_NONBLOCK\r\ndebug2: mux_client_hello_exchange: master version 4\r\ndebug3: mux_client_forwards: request forwardings: 0 local, 0 remote\r\ndebug3: mux_client_request_session: entering\r\ndebug3: mux_client_request_alive: entering\r\ndebug3: mux_client_request_alive: done pid = 12826\r\ndebug3: mux_client_request_session: session request sent\r\ndebug1: mux_client_request_session: master session id: 2\r\ndebug3: mux_client_read_packet: read header failed: Broken pipe\r\ndebug2: Received exit status from master 0\r\nShared connection to localhost closed.\r\n",
"module_stdout": "Traceback (most recent call last):\r\n File "/tmp/ansible_Z013Jt/ansible_module_xls_to_facts.py", line 144, in \r\n main()\r\n File "/tmp/ansible_Z013Jt/ansible_module_xls_to_facts.py", line 134, in main\r\n code, response = read_xls_dict(module.params["src"])\r\n File "/tmp/ansible_Z013Jt/ansible_module_xls_to_facts.py", line 103, in read_xls_dict\r\n wb = openpyxl.load_workbook(input_file)\r\n File "/usr/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 171, in load_workbook\r\n archive = _validate_archive(filename)\r\n File "/usr/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 121, in _validate_archive\r\n archive = ZipFile(f, 'r', ZIP_DEFLATED)\r\n File "/usr/lib64/python2.7/zipfile.py", line 766, in init\r\n self._RealGetContents()\r\n File "/usr/lib64/python2.7/zipfile.py", line 807, in _RealGetContents\r\n raise BadZipfile, "File is not a zip file"\r\nzipfile.BadZipfile: File is not a zip file\r\n",
"msg": "MODULE FAILURE",
"rc": 0
}

The verbose output can be found here https://pastebin.com/mpFp17K1
I created another spreadsheet and renamed to 'example.xlsx' but the result was the same. The file is not a zip file in both cases:

[ansible@devops ansible_xls_to_facts]$ file example.xlsx
example.xlsx: Microsoft Excel 2007+

I would be grateful if you could guide me on this issue.

Many thanks

Best regards

Iban

I attempted to use this on a cell that is using a formula. The resulting variable is the function itself and not the output of the function. Any idea of how to resolve this?

Hi,

i am following your video how to build evpn by getting information from XLS.

Appreciate if you are able to share yaml to call xls_to_facts module created on your github

i am trying the yaml as below but it still doesn;t work

• name: Import host-specific facts from a XLS file
  xls_to_facts:
  src: "evpn_config_template.xlsx"

• name: Render switch global configuration commands
  template:
  src: spine_global.j2
  dest: "{{configuration_file.type}}"

Thanks,
Best Regards,
Yansen