xlsx2csv
xlsx2csv copied to clipboard
dilshod
Convert xslx to csv, it is fast, and works for huge xlsx files
Thanks a lot for your great work. It is really helpful. Depending on the xlsx received, I can see a large mismatch between the xlsx converted into csv by excel...
- 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...
skip_trailing_columns: don't assume the first line to be the longest and use pop to speed the computation, as it's now done for each line of the sheet
Not sure what's the state of python version support in this project, at least it seems pyproject.toml is a bit outdated. xlsx2csv 0.8.2 does not work with python 3.6, as...
In 0.8.2, Python 3.12 complains about '\\[' being bad syntax for a regexp in line 836. I prefixed the regexp string with an r, after which it peacefully works.
save the `ts` column into test.xlsx ``` ts 2023-10-31 00:39:00 ``` convert test.xlsx to test.csv: ```bash xlsx2csv test.xlsx test.csv --dateformat '%Y-%m-%d %H:%M:%S' ``` the datetime `2023-10-31 00:39:00` is convert to...
I modified output string of error message to include row, column and value causing date format error so it's easier to find a problem with source file. Output looks like...
I am trying: ``` from xlsx2csv import Xlsx2csv Xlsx2csv('Book1.xlsx', sheet_name='Sheet2').convert('myfile.csv') ``` But it always saving the first worksheet. Tried versions `0.8.0` and `0.7.8`. My python version is `3.10.5 64-bit`.
Hi there, I have an XLSX file with a text column. In this column sometimes the value "#nv" occurs. When trying to convert this file, I got the error "wrong...
