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/2009/12/xlsx2csv/
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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file xlsx2csv-0.6.1.tar.gz.
File metadata
- Download URL: xlsx2csv-0.6.1.tar.gz
- Upload date:
- Size: 188.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
6d2b630926d8dd8fae2cbb003a65a642691ad4d81520a3d18bfcc8a7ac2b107b
|
|
| MD5 |
50682fe06aab176979f4ca7734b1445e
|
|
| BLAKE2b-256 |
0730d9c8fe21ddf243b778407a885b90002d65c52ba4a9751dc166417fa6b20e
|
File details
Details for the file xlsx2csv-0.6.1.macosx-10.9-intel.exe.
File metadata
- Download URL: xlsx2csv-0.6.1.macosx-10.9-intel.exe
- Upload date:
- Size: 78.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
bd0872ac1a1ca36556e9d6f108fedd303cc15e858fa672b45177fcecb0f5b546
|
|
| MD5 |
533a751c9fc121096a3c0fe97f81024a
|
|
| BLAKE2b-256 |
4244837266d1e739f662e917b7d9af0a2c70fa0be1e4f7d0dadd1ed6e1b9bd30
|
