New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Listed python alternatives are out of date #279

Open

boxydog opened this issue Apr 3, 2024 · 2 comments

Contributor

boxydog commented Apr 3, 2024

https://github.com/staale/py-xlsx last updated 9 years ago
https://github.com/leegao/pyXLSX last updated 14 years ago

It makes me a bit nervous to use something so old with modern pythons.

When I searched for python xlsx, I got:

openpyxl - last updated 2023
pandas.read_excel - seems heavyweight
pyexcel - last updated 9 months ago, but not passing its tests
a whole page of alternatives

It's a confusing world out there, I'm not sure what the best alternative is.

Contributor Author

boxydog commented Apr 3, 2024

Upon reflection, pandas is likely the most supported, even though it's heavyweight for this.

Contributor Author

boxydog commented Apr 3, 2024

Sorry to keep chattering about this, but I think like pandas uses openpyxl by default.

See https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html

engine{‘openpyxl’, ‘calamine’, ‘odf’, ‘pyxlsb’, ‘xlrd’}, default None

Also see https://openpyxl.readthedocs.io/en/stable/pandas.html.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment