xlsx to csv converter (http://github.com/dilshod/xlsx2csv)
Converts xslx files to csv format. Handles large XLSX files. Fast and easy to use.
- Installation:
sudo easy_install xlsx2csv or pip install xlsx2csv
- Usage:
- xlsx2csv.py [-h] [-v] [-a] [-d DELIMITER] [-f DATEFORMAT] [-i] [-e]
[-p SHEETDELIMITER] [-s SHEETID] [–hyperlinks] [-I INCLUDE_SHEET_PATTERN] [-E EXCLUDE_SHEET_PATTERN] xlsxfile [outfile]
xlsxfile xlsx file path outfile output csv file path
- optional arguments:
- -h, --help
show this help message and exit
- -v, --version
show program’s version number and exit
- -a, --all
export all sheets
- -d DELIMITER, --delimiter DELIMITER
delimiter - columns delimiter in csv, ‘tab’ or ‘x09’ for a tab (default: comma ‘,’)
- -f DATEFORMAT, --dateformat DATEFORMAT
override date/time format (ex. %Y/%m/%d)
- -i, --ignoreempty
skip empty lines
- -e, --escape
Escape rnt characters
- -p SHEETDELIMITER, --sheetdelimiter SHEETDELIMITER
sheet delimiter used to separate sheets, pass ‘’ if you do not need delimiter (default: ‘——–‘)
- -s SHEETID, --sheet SHEETID
sheet number to convert
- --hyperlinks
include hyperlinks
- -I INCLUDE_SHEET_PATTERN, --include INCLUDE_SHEET_PATTERN
only include sheets named matching given pattern, only effects when -a option is enabled.
- -E EXCLUDE_SHEET_PATTERN, --exclude EXCLUDE_SHEET_PATTERN
exclude sheets named matching given pattern, only effects when -a option is enabled.
Expat SAX parser used for xml parsing.
See alternatives:
Bash: http://kirk.webfinish.com/?p=91
Python: http://github.com/staale/python-xlsx http://github.com/leegao/pyXLSX
Ruby: http://roo.rubyforge.org/
Java: http://poi.apache.org/
All programs in this directory and subdirectories are published under license GNU GPL version 2 or (at your option) any later version. For more information, see COPYING or visit <http://www.gnu.org/copyleft/gpl.html>.
1 maintainer
Metadata
1 maintainer
Release files for xlsx2csv 0.7.2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| xlsx2csv-0.7.2.tar.gz | 188.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| xlsx2csv-0.7.2.macosx-10.10-intel.exe | Details |
Total release size: 267.4 kB
Release files / xlsx2csv-0.7.2.tar.gz
| Download URL | xlsx2csv-0.7.2.tar.gz |
|---|---|
| Size | 188.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
7c6c8fa6c2774224d03a6a96049e116822484dccfa3634893397212ebcd23866
|
|
BLAKE2b-256 checksum How to use checksums |
9f6924d590eeea095e8cadb8301aaffdc665f00e08a154e36f2a7ef3c0d179f8
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / xlsx2csv-0.7.2.macosx-10.10-intel.exe
| Download URL | xlsx2csv-0.7.2.macosx-10.10-intel.exe |
|---|---|
| Size | 78.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
302ab9c29bada5bd238bbe92618ade7877582ce56da72ff2ca882de08d015a15
|
|
BLAKE2b-256 checksum How to use checksums |
6aa58916244157988d4053c59f16bf14b13db335ab0c4749640aa2eb3687472e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
