The xlsx2csv from hehaotian

xlsx2csv's Introduction

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 \r\n\t 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>.

Recommend Projects