xlsx2csv icon indicating copy to clipboard operation
xlsx2csv copied to clipboard

Listed python alternatives are out of date

Open boxydog opened this issue 1 year ago • 2 comments

  • 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:

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

boxydog avatar Apr 03 '24 17:04 boxydog

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

boxydog avatar Apr 03 '24 18:04 boxydog

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.

boxydog avatar Apr 03 '24 18:04 boxydog