xlsx to csv converter (http://github.com/dilshod/xlsx2csv)
Converts xslx files to csv format. Handles large XLSX files. Fast and easy to use.
- Installation:
sudo easy_install xlsx2csv or pip install xlsx2csv
- Usage:
- xlsx2csv.py [-h] [-v] [-a] [-d DELIMITER] [-f DATEFORMAT] [-i] [-e]
[-p SHEETDELIMITER] [-s SHEETID] [–hyperlinks] [-I INCLUDE_SHEET_PATTERN] [-E EXCLUDE_SHEET_PATTERN] xlsxfile [outfile]
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
- -d DELIMITER, --delimiter DELIMITER
delimiter - columns delimiter in csv, ‘tab’ or ‘x09’ for a tab (default: comma ‘,’)
- -f DATEFORMAT, --dateformat DATEFORMAT
override date/time format (ex. %Y/%m/%d)
- -i, --ignoreempty
skip empty lines
- -e, --escape
Escape rnt characters
- -p SHEETDELIMITER, --sheetdelimiter SHEETDELIMITER
sheet delimiter used to separate sheets, pass ‘’ if you do not need delimiter (default: ‘——–‘)
- -s SHEETID, --sheet SHEETID
sheet number to convert
- --hyperlinks
include hyperlinks
- -I INCLUDE_SHEET_PATTERN, --include INCLUDE_SHEET_PATTERN
only include sheets named matching given pattern, only effects when -a option is enabled.
- -E EXCLUDE_SHEET_PATTERN, --exclude EXCLUDE_SHEET_PATTERN
exclude sheets named matching given pattern, only effects when -a option is enabled.
Expat SAX parser used for xml parsing.
See alternatives:
Bash: http://kirk.webfinish.com/2009/12/xlsx2csv/
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>.
1 maintainer
Metadata
1 maintainer
Release files for xlsx2csv 0.6.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| xlsx2csv-0.6.1.tar.gz | 188.8 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| xlsx2csv-0.6.1.macosx-10.9-intel.exe | Details |
Total release size: 267.5 kB
Release files / xlsx2csv-0.6.1.tar.gz
| Download URL | xlsx2csv-0.6.1.tar.gz |
|---|---|
| Size | 188.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
6d2b630926d8dd8fae2cbb003a65a642691ad4d81520a3d18bfcc8a7ac2b107b
|
|
BLAKE2b-256 checksum How to use checksums |
0730d9c8fe21ddf243b778407a885b90002d65c52ba4a9751dc166417fa6b20e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / xlsx2csv-0.6.1.macosx-10.9-intel.exe
| Download URL | xlsx2csv-0.6.1.macosx-10.9-intel.exe |
|---|---|
| Size | 78.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
bd0872ac1a1ca36556e9d6f108fedd303cc15e858fa672b45177fcecb0f5b546
|
|
BLAKE2b-256 checksum How to use checksums |
4244837266d1e739f662e917b7d9af0a2c70fa0be1e4f7d0dadd1ed6e1b9bd30
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Security for xlsx2csv 0.6.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
