aforward-oss / xlsx2csv Goto Github PK

xlsx to csv convertor (http://github.com/dilshod/xlsx2csv)

Converts xslx xml excel files to csv format.
It is fast, and works for huge xlsx files.

Usage: xlsx2csv.py [options] infile [outfile]

Options:
  --version             show program's version number and exit
  -h, --help            show this help message and exit
  -s SHEETID, --sheet=SHEETID
                        sheet no to convert (0 for all sheets)
  -d DELIMITER, --delimiter=DELIMITER
                        delimiter - csv columns delimiter, 'tab' or 'x09' for
                        tab (comma is default)
  -p SHEETDELIMITER, --sheetdelimiter=SHEETDELIMITER
                        sheets delimiter used to separate sheets, pass '' if
                        you don't want delimiters (default '--------')
  -f DATEFORMAT, --dateformat=DATEFORMAT
                        override date/time format (ex. %Y/%m/%d)

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>.