| Name | xlsx2csv JSON |
| Version |
0.8.4
JSON |
| download |
| home_page | None |
| Summary | xlsx to csv converter |
| upload_time | 2024-11-19 17:06:07 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | None |
| license | None |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# 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.
## Tested(supported) python versions:
- 2.4
- 2.7
- 3.4 to 3.12
## 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, use '-' to read from STDIN
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 with folder containing multiple `xlxs` files:
```
python xlsx2csv.py /path/to/input/dir /path/to/output/dir
```
will output each file in the input dir converted to `.csv` in the output dir. If omitting the output dir it will output the converted files in the input dir
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/
## Meta
Dilshod Temirkhdojaev – tdilshod@gmail.com
Distributed under the MIT LICENSE. See ``LICENSE`` for more information.
[https://github.com/dilshod](https://github.com/dilshod)
Raw data
{
"_id": null,
"home_page": null,
"name": "xlsx2csv",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": null,
"author": null,
"author_email": "Dilshod Temirkhdojaev <tdilshod@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/36/20/94860286a308a4213581c1beacd4fc7be724250c03583fcff23aaa6107bb/xlsx2csv-0.8.4.tar.gz",
"platform": null,
"description": "\n# xlsx2csv\n\n> xlsx to csv converter (http://github.com/dilshod/xlsx2csv)\n\nConverts xlsx files to csv format.\nHandles large XLSX files. Fast and easy to use.\n\n## Tested(supported) python versions:\n - 2.4\n - 2.7\n - 3.4 to 3.12\n\n## Installation:\n\n```sh\nsudo easy_install xlsx2csv\n```\n or\n\n```sh\npip install xlsx2csv\n```\n\n\n Also, works standalone with only the *xlsx2csv.py* script\n\n**Usage:**\n```\n xlsx2csv.py [-h] [-v] [-a] [-c OUTPUTENCODING] [-s SHEETID]\n [-n SHEETNAME] [-d DELIMITER] [-l LINETERMINATOR]\n [-f DATEFORMAT] [--floatformat FLOATFORMAT]\n [-i] [-e] [-p SHEETDELIMITER]\n [--hyperlinks]\n [-I INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN ...]]\n [-E EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN ...]] [-m]\n xlsxfile [outfile]\n```\n**positional arguments:**\n```\n xlsxfile xlsx file path, use '-' to read from STDIN\n outfile output csv file path, or directory if -s 0 is specified\n```\n**optional arguments:**\n```\n -h, --help show this help message and exit\n -v, --version show program's version number and exit\n -a, --all export all sheets\n -c OUTPUTENCODING, --outputencoding OUTPUTENCODING\n encoding of output csv ** Python 3 only ** (default: utf-8)\n -s SHEETID, --sheet SHEETID\n sheet number to convert, 0 for all\n -n SHEETNAME, --sheetname SHEETNAME\n sheet name to convert\n -d DELIMITER, --delimiter DELIMITER\n delimiter - columns delimiter in csv, 'tab' or 'x09'\n for a tab (default: comma ',')\n -l LINETERMINATOR, --lineterminator LINETERMINATOR\n line terminator - lines terminator in csv, '\\n' '\\r\\n'\n or '\\r' (default: os.linesep)\n -f DATEFORMAT, --dateformat DATEFORMAT\n override date/time format (ex. %Y/%m/%d)\n --floatformat FLOATFORMAT\n override float format (ex. %.15f)\n -i, --ignoreempty skip empty lines\n -e, --escape Escape \\r\\n\\t characters\n -p SHEETDELIMITER, --sheetdelimiter SHEETDELIMITER\n sheet delimiter used to separate sheets, pass '' if\n you do not need delimiter, or 'x07' or '\\\\f' for form\n feed (default: '--------')\n -q QUOTING, --quoting QUOTING\n field quoting, 'none' 'minimal' 'nonnumeric' or 'all' (default: 'minimal')\n --hyperlinks, --hyperlinks\n include hyperlinks\n -I INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN ...], --include_sheet_pattern INCLUDE_SHEET_PATTERN [INCLUDE_SHEET_PATTERN ...]\n only include sheets named matching given pattern, only\n effects when -a option is enabled.\n -E EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN ...], --exclude_sheet_pattern EXCLUDE_SHEET_PATTERN [EXCLUDE_SHEET_PATTERN ...]\n exclude sheets named matching given pattern, only\n effects when -a option is enabled.\n -m, --merge-cells merge cells\n```\n\nUsage with folder containing multiple `xlxs` files:\n```\n python xlsx2csv.py /path/to/input/dir /path/to/output/dir\n```\nwill output each file in the input dir converted to `.csv` in the output dir. If omitting the output dir it will output the converted files in the input dir\n\nUsage from within Python:\n```\n from xlsx2csv import Xlsx2csv\n Xlsx2csv(\"myfile.xlsx\", outputencoding=\"utf-8\").convert(\"myfile.csv\")\n```\n\nExpat SAX parser used for xml parsing.\n\nSee alternatives:\n\nBash:\nhttp://kirk.webfinish.com/?p=91\n\nPython:\nhttp://github.com/staale/python-xlsx\nhttp://github.com/leegao/pyXLSX\n\nRuby:\nhttp://roo.rubyforge.org/\n\nJava:\nhttp://poi.apache.org/\n\n\n## Meta\n\n Dilshod Temirkhdojaev \u2013 tdilshod@gmail.com\n\nDistributed under the MIT LICENSE. See ``LICENSE`` for more information.\n\n[https://github.com/dilshod](https://github.com/dilshod)\n",
"bugtrack_url": null,
"license": null,
"summary": "xlsx to csv converter",
"version": "0.8.4",
"project_urls": {
"Homepage": "http://github.com/dilshod/xlsx2csv"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c4c015c21556362c67f1155f3643a375d50ac67559b82c768e64e800a42a2577",
"md5": "aca8e8f18205e4ca1c8bef6491f1b968",
"sha256": "52ab873fc7b2f2ca75d14aee8bd1985a9f5c1bcb3cc7b80df7a5d57a40a67473"
},
"downloads": -1,
"filename": "xlsx2csv-0.8.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "aca8e8f18205e4ca1c8bef6491f1b968",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 15904,
"upload_time": "2024-11-19T17:06:05",
"upload_time_iso_8601": "2024-11-19T17:06:05.362913Z",
"url": "https://files.pythonhosted.org/packages/c4/c0/15c21556362c67f1155f3643a375d50ac67559b82c768e64e800a42a2577/xlsx2csv-0.8.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "362094860286a308a4213581c1beacd4fc7be724250c03583fcff23aaa6107bb",
"md5": "ffe4aa6fdabae6c701e23097a78d3712",
"sha256": "2aa809888826f6af5b26c77fc7f613f2bbeada0d8cc09e5a58e0f59684bb6911"
},
"downloads": -1,
"filename": "xlsx2csv-0.8.4.tar.gz",
"has_sig": false,
"md5_digest": "ffe4aa6fdabae6c701e23097a78d3712",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 221390,
"upload_time": "2024-11-19T17:06:07",
"upload_time_iso_8601": "2024-11-19T17:06:07.818517Z",
"url": "https://files.pythonhosted.org/packages/36/20/94860286a308a4213581c1beacd4fc7be724250c03583fcff23aaa6107bb/xlsx2csv-0.8.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-19 17:06:07",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "dilshod",
"github_project": "xlsx2csv",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "xlsx2csv"
}
