Skip to content
This repository has been archived by the owner on Jul 19, 2023. It is now read-only.

Database filetype xlsx not supported fix #48

Open
NICKCHEESE opened this issue Dec 20, 2020 · 5 comments
Open

Database filetype xlsx not supported fix #48

NICKCHEESE opened this issue Dec 20, 2020 · 5 comments

Comments

@NICKCHEESE
Copy link

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.

@d3vilbug
Copy link

yes, it's working with this 😐

@pyhoff
Copy link

pyhoff commented Jan 8, 2021

  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

@preetharman40
Copy link

Thankx @NICKCHEESE , it worked for me also

@netpr1s0ner
Copy link

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

@cybert0ucan
Copy link

Thanks! What a life-saver!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

6 participants