Convert Large Excel File to CSV/TSV
Project description
Convert Large Excel File to CSV/TSV
Installation
python3 -m pip install -U large_excel_convert
Usage
Use in CMD
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
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)
# ...
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file large_excel_convert-1.0.2.tar.gz
.
File metadata
- Download URL: large_excel_convert-1.0.2.tar.gz
- Upload date:
- Size: 4.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.8.8
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 46a9954288df1d7d83eb44b99c564808ea3ba4f01045fa88602751d3a26644f6 |
|
MD5 | a75b647b5249f675e1cf336995ba7b66 |
|
BLAKE2b-256 | 699330d58d22cc1aeb870864fcdf0e1518b5ced6244057491a987907afe4b213 |
File details
Details for the file large_excel_convert-1.0.2-py3-none-any.whl
.
File metadata
- Download URL: large_excel_convert-1.0.2-py3-none-any.whl
- Upload date:
- Size: 6.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.8.8
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | da8680ede1cd30b364fe420b46b03cc913eab0a4595c7fc236296f08c4ed50a8 |
|
MD5 | 287d0e6a9600a99c3d838601f8f18be8 |
|
BLAKE2b-256 | 3eb9853b31f2201f658ca50ceafa784ac98b7dcd1b05b4c2e29b31719a2f3eff |