Skip to content
/ xlsx2csv Public
forked from dilshod/xlsx2csv

Convert xslx to csv, it is fast, and works for huge xlsx files

License

GPL-3.0, Unknown licenses found

Licenses found

GPL-3.0
LICENSE.txt
Unknown
COPYING
Notifications You must be signed in to change notification settings

hcw70/xlsx2csv

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Convert xslx to csv, it is fast, and works for huge xlsx files

Resources

License

GPL-3.0, Unknown licenses found

Licenses found

GPL-3.0
LICENSE.txt
Unknown
COPYING

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Python 89.2%
  • Perl 6.3%
  • Makefile 4.5%