# Convert Large Excel File to CSV/TSV
## Installation
```bash
python3 -m pip install -U large_excel_convert
```
## Usage
### Use in CMD
```bash
large_excel_convert -h
large_excel_convert -i input.xlsx
large_excel_convert -i input.xlsx -o output.csv
large_excel_convert -i input.xlsx -o output.csv -enc gb18030
large_excel_convert -i input.xlsx -o output.tsv -f tsv
large_excel_convert -i input.xlsx -o sheet2.csv -s 2
```
### Use in Python
```python
from large_excel_convert.core import ExcelParser
# excel = ExcelParser('input.xlsx', sheet=1, tag='row')
excel = ExcelParser('input.xlsx')
rows = excel.rows()
for row in rows:
print(row)
# ...
````
Raw data
{
"_id": null,
"home_page": "https://github.com/suqingdong/large_excel_convert",
"name": "large-excel-convert",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": null,
"author": "suqingdong",
"author_email": "suqingdong1114@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/69/93/30d58d22cc1aeb870864fcdf0e1518b5ced6244057491a987907afe4b213/large_excel_convert-1.0.2.tar.gz",
"platform": null,
"description": "# Convert Large Excel File to CSV/TSV\n\n## Installation\n\n```bash\npython3 -m pip install -U large_excel_convert\n```\n\n## Usage\n\n### Use in CMD\n\n```bash\n\nlarge_excel_convert -h\nlarge_excel_convert -i input.xlsx\nlarge_excel_convert -i input.xlsx -o output.csv\nlarge_excel_convert -i input.xlsx -o output.csv -enc gb18030\nlarge_excel_convert -i input.xlsx -o output.tsv -f tsv\nlarge_excel_convert -i input.xlsx -o sheet2.csv -s 2\n```\n\n### Use in Python\n\n```python\nfrom large_excel_convert.core import ExcelParser\n\n# excel = ExcelParser('input.xlsx', sheet=1, tag='row')\nexcel = ExcelParser('input.xlsx')\nrows = excel.rows()\n\nfor row in rows:\n print(row)\n # ...\n````\n\n\n",
"bugtrack_url": null,
"license": "MIT License",
"summary": "Convert Large Excel File to CSV/TSV",
"version": "1.0.2",
"project_urls": {
"Homepage": "https://github.com/suqingdong/large_excel_convert"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "3eb9853b31f2201f658ca50ceafa784ac98b7dcd1b05b4c2e29b31719a2f3eff",
"md5": "287d0e6a9600a99c3d838601f8f18be8",
"sha256": "da8680ede1cd30b364fe420b46b03cc913eab0a4595c7fc236296f08c4ed50a8"
},
"downloads": -1,
"filename": "large_excel_convert-1.0.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "287d0e6a9600a99c3d838601f8f18be8",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 6081,
"upload_time": "2024-11-15T06:10:54",
"upload_time_iso_8601": "2024-11-15T06:10:54.083669Z",
"url": "https://files.pythonhosted.org/packages/3e/b9/853b31f2201f658ca50ceafa784ac98b7dcd1b05b4c2e29b31719a2f3eff/large_excel_convert-1.0.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "699330d58d22cc1aeb870864fcdf0e1518b5ced6244057491a987907afe4b213",
"md5": "a75b647b5249f675e1cf336995ba7b66",
"sha256": "46a9954288df1d7d83eb44b99c564808ea3ba4f01045fa88602751d3a26644f6"
},
"downloads": -1,
"filename": "large_excel_convert-1.0.2.tar.gz",
"has_sig": false,
"md5_digest": "a75b647b5249f675e1cf336995ba7b66",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 4214,
"upload_time": "2024-11-15T06:10:55",
"upload_time_iso_8601": "2024-11-15T06:10:55.780412Z",
"url": "https://files.pythonhosted.org/packages/69/93/30d58d22cc1aeb870864fcdf0e1518b5ced6244057491a987907afe4b213/large_excel_convert-1.0.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-15 06:10:55",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "suqingdong",
"github_project": "large_excel_convert",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [
{
"name": "lxml",
"specs": []
},
{
"name": "click",
"specs": []
},
{
"name": "loguru",
"specs": []
},
{
"name": "humanfriendly",
"specs": []
}
],
"lcname": "large-excel-convert"
}
JSON
