xlsx2csv 0.7.2

xlsx to csv converter

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