gknor / xlsx2csv Goto Github PK
View Code? Open in Web Editor NEWThis project forked from dilshod/xlsx2csv
Convert xslx to csv, it is fast, and works for huge xlsx files
License: GNU General Public License v3.0
This project forked from dilshod/xlsx2csv
Convert xslx to csv, it is fast, and works for huge xlsx files
License: GNU General Public License v3.0
xlsx to csv converter (http://github.com/dilshod/xlsx2csv) Converts xslx files to csv format. Handles large XLSX files. Fast and easy to use. Supported version: - 2.4 - 2.7 - 3.4 Installation: sudo easy_install xlsx2csv or pip install xlsx2csv Usage: xlsx2csv.py [-h] [-v] [-a] [-c OUTPUTENCODING] [-s SHEETID] [-n SHEETNAME] [-d DELIMITER] [-l LINETERMINATOR] [-f DATEFORMAT] [-i] [-e] [-p SHEETDELIMITER] [--hyperlinks] [-I INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN ...]] [-E EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN ...]] [-m] xlsxfile [outfile] positional arguments: 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 -c OUTPUTENCODING, --outputencoding OUTPUTENCODING encoding of output csv ** Python 3 only ** (default: utf-8) -s SHEETID, --sheet SHEETID sheet number to convert -n SHEETNAME, --sheetname SHEETNAME sheet name to convert -d DELIMITER, --delimiter DELIMITER delimiter - columns delimiter in csv, 'tab' or 'x09' for a tab (default: comma ',') -l LINETERMINATOR, --lineterminator LINETERMINATOR line terminator - lines terminator in csv, '\n' '\r\n' or '\r' (default: os.linesep) -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, or 'x07' or '\\f' for form feed (default: '--------') --hyperlinks, --hyperlinks include hyperlinks -I INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN ...], --include_sheet_pattern INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN ...] only include sheets named matching given pattern, only effects when -a option is enabled. -E EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN ...], --exclude_sheet_pattern EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN ...] exclude sheets named matching given pattern, only effects when -a option is enabled. -m, --merge-cells merge cells 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>.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.