xlsx to csv converter
Project description
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>.
Project details
Release history Release notifications | RSS feed
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
Hashes for xlsx2csv-0.7.2.macosx-10.10-intel.exe
Algorithm | Hash digest | |
---|---|---|
SHA256 | 302ab9c29bada5bd238bbe92618ade7877582ce56da72ff2ca882de08d015a15 |
|
MD5 | 0eb431cfb2b22ae5c1410eaa1c514100 |
|
BLAKE2b-256 | 6aa58916244157988d4053c59f16bf14b13db335ab0c4749640aa2eb3687472e |