csv2xls
Put together some CSV files into a single Excel file, in different sheets.
Installation
You can install directly after cloning:
$ python setup.py install --user
Or use the Python package:
$ pip install --user csv2xls
Dependency
Outside the standard library, the xlwt package is needed, and should be automatically installed with setuptools. Otherwise:
$ pip install --user xlwt
Example
$ csv2xls examples/sheet_alpha.csv examples/sheet_beta.csv -o output.xls
Processing examples/sheet_alpha.csv -> output.xls/alpha
Processing examples/sheet_beta.csv -> output.xls/beta
Usage
$ csv2xls -h
usage: csv2xls [-h] [-o OUTPUT] [-c] [-d DELIMITER] [-q QUOTECHAR] [-n]
[-D FORMAT] [-k]
files [files ...]
Put together some CSV files into a single Excel file. Basic types are inferred
automatically.
positional arguments:
files
optional arguments:
-h, --help show this help message and exit
-o OUTPUT, --output OUTPUT
Define name for output Excel file. Default is
"output.xls".
-c, --clean Delete input files afterwards, if successful.
-d DELIMITER, --delimiter DELIMITER
Change row delimiter. Default is ",".
-q QUOTECHAR, --quotechar QUOTECHAR
Change quoting character. Default way of quoting is
"that is, quoted".
-n, --no-type-inference
Do not try to infer int/float/date when writing. This
mode is faster and preserves input data.
-D FORMAT, --date-format FORMAT
Change date format used during date type inference.
Default is "%Y-%m-%d".
-k, --keep-prefix Keep common prefix when building sheet names. Default
is to remove the common prefix of input file names.
Example: csv2xls examples/sheet_alpha.csv examples/sheet_beta.csv
Tests
To run the tests, you must install xls2txt:
$ git clone https://github.com/hroptatyr/xls2txt.git
$ cd xls2txt
$ make
$ sudo make install
Then run:
$ ./tests.sh
Metadata
Release files for csv2xls 0.4
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 | Actions |
|---|---|---|---|---|
| csv2xls-0.4.tar.gz | 13.4 kB | Without provenance | Details for csv2xls-0.4.tar.gz |
Release files / csv2xls-0.4.tar.gz
| Download URL | csv2xls-0.4.tar.gz |
|---|---|
| Size | 13.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
17d708576afcae6a18abdfe887fcb51169e28b4ec988476acfe12cf24b31b36a
|
|
BLAKE2b-256 checksum How to use checksums |
aa5d52f96a166ffb2e05db63caf83fdcc788b56c3d666532b573a253ffeb7cd2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Security for csv2xls 0.4
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.
To learn more about protecting yourself from malicious actors, visit our package security documentation.