csv2xls

Put together some CSV files into a single Excel file, in different sheets.

Installation

You can install directly after cloning:

.. code-block:: bash

$ python setup.py install --user

Or use the Python package:

.. code-block:: bash

$ pip install --user csv2xls

Dependency

Outside the standard library, the xlwt <http://www.python-excel.org/>_ package is needed, and should be automatically installed with setuptools. Otherwise:

.. code-block:: bash

$ pip install --user xlwt

Example

.. code-block:: bash

$ 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

.. code-block:: bash

$ 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 <https://github.com/hroptatyr/xls2txt>_:

.. code-block:: bash

$ git clone https://github.com/hroptatyr/xls2txt.git $ cd xls2txt $ make $ sudo make install

Then run:

.. code-block:: bash

$ ./tests.sh