diff options
Diffstat (limited to 'Tools/XlsToCsv/README.md')
| -rw-r--r-- | Tools/XlsToCsv/README.md | 119 |
1 files changed, 0 insertions, 119 deletions
diff --git a/Tools/XlsToCsv/README.md b/Tools/XlsToCsv/README.md deleted file mode 100644 index e7bd612..0000000 --- a/Tools/XlsToCsv/README.md +++ /dev/null @@ -1,119 +0,0 @@ - -# xlsx2csv - -> xlsx to csv converter (http://github.com/dilshod/xlsx2csv) - -Converts xlsx files to csv format. -Handles large XLSX files. Fast and easy to use. - -## Supported python versions: - - 2.4 - - 2.7 - - 3.4 - -## Installation: - -```sh -sudo easy_install xlsx2csv -``` - or - -```sh -pip install xlsx2csv -``` - - - Also, works standalone with only the *xlsx2csv.py* script - -**Usage:** -``` - xlsx2csv.py [-h] [-v] [-a] [-c OUTPUTENCODING] [-s SHEETID] - [-n SHEETNAME] [-d DELIMITER] [-l LINETERMINATOR] - [-f DATEFORMAT] [--floatformat FLOATFORMAT] - [-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, or directory if -s 0 is specified -``` -**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, 0 for all - -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) - --floatformat FLOATFORMAT - override float format (ex. %.15f) - -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: '--------') - -q QUOTING, --quoting QUOTING - field quoting, 'none' 'minimal' 'nonnumeric' or 'all' (default: 'minimal') - --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 -``` - -Usage from within Python: -``` - from xlsx2csv import Xlsx2csv - Xlsx2csv("myfile.xlsx", outputencoding="utf-8").convert("myfile.csv") -``` - -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 <https://www.gnu.org/licenses/old-licenses/gpl-2.0.html>. - - -## Meta - - Dilshod Temirkhdojaev – tdilshod@gmail.com - -Distributed under the GNU GENERAL PUBLIC LICENSE. See ``LICENSE`` for more information. - -[https://github.com/dilshod](https://github.com/dilshod) |