Help setting up and troubleshooting steps to install Python etc. for XLS to XML conversion project
Budget: $30 – $250 USD
I need help setting up correct version/s Python to run a script that uses the XLRD library to convert XLS to XML. I need to understand what's going wrong so I can repeat correct steps on other machines in future. The .py script worked on well on a Windows 10 machine with both python 2.7 and 3.11 installed but I can't remember the installation order and process enough to repeat- The working machine can be access remotely and referenced if needed, but now I'm trying to run on Windows 11 without success. I'm not very experienced with this so I'm at the end of the rope.
To help understand the project workflow - Data on an Excel spreadsheet is updated on a computer on the network. I will have a sync utility to see the file change on the network folder which will then trigger a batch file which runs the py script to execute the xls to xml conversion and saves to a local folder. I've attached the py script and xls doc here as well.
The problem I'm having on the new machine is, the script will save the XML but there's no data. I'm wondering if there's a library path or environment setup incorrectly or if it's just an incompatibility with the python version and /or os system. There could be some minor coding required but as I mentioned the script currently works great on another machine.
To help understand the project workflow - Data on an Excel spreadsheet is updated on a computer on the network. I will have a sync utility to see the file change on the network folder which will then trigger a batch file which runs the py script to execute the xls to xml conversion and saves to a local folder. I've attached the py script and xls doc here as well.
The problem I'm having on the new machine is, the script will save the XML but there's no data. I'm wondering if there's a library path or environment setup incorrectly or if it's just an incompatibility with the python version and /or os system. There could be some minor coding required but as I mentioned the script currently works great on another machine.