Database filetype xlsx not supported fix
NICKCHEESE opened this issue ยท 5 comments
Not sure if anyone else has had this issue come up when trying to run this but here's what I did:
Run the database update command as normal
Rename the database file FROM .xls TO .xlsx
Then use as online tool to convert it back into .xls format. Stupid I know. I used (https://www.zamzar.com/convert/xlsx-to-xls/)
Save the file and replace your existing one and run the script as you normally would.
At least this worked for me. Maybe it'll help someone else out too.
yes, it's working with this ๐
-
use Python3 and venev. --https://medium.com/swlh/how-to-setup-your-python-projects-1eb5108086b1
-
need to install older an version of xlrd, for example
pip2 install --user xlrd==1.1.0
Thankx @NICKCHEESE , it worked for me also
1. use Python3 and venev. --https://medium.com/swlh/how-to-setup-your-python-projects-1eb5108086b1 2. need to install older an version of xlrd, for example pip2 install --user xlrd==1.1.0
nice
Thanks! What a life-saver!