txt2xls 0.1.0

Installation

Use pip like:

$ pip install txt2xls

Quick Usage

Assume there are several raw text data files like:

# Sample1.txt
0 10
1 20
2 30
3 40
4 50
5 60
# Sample2.txt
0 15
1 25
2 35
3 45
4 55
5 65
# Sample3.txt
0 12
1 22
2 32
3 42
4 52
5 62

Then run txt2xls with

% txt2xls -o output Sample*.txt

It will produce output.xls file. The excel file have Sample1, Sample2, and Sample3 sheets.

Usage

usage: txt2xls [-h] [-v] [-o OUTPUT] [--raise-exceptions] [-p PARSER]
            [-l LOADER] [-a] [--unite-basecolumn UNITE_BASECOLUMN]
            [-u USING] [--relative] [--relative-origin RELATIVE_ORIGIN]
            [--relative-basecolumn RELATIVE_BASECOLUMN]
            [--baseline BASELINE] [--baseline-column BASELINE_COLUMN]
            [--baseline-function BASELINE_FUNCTION]
            infiles [infiles ...]

positional arguments:
infiles               Path list of data files or directories which have data
                        files.

optional arguments:
-h, --help            show this help message and exit
-v, --version         show program's version number and exit
-o OUTPUT, --output OUTPUT
                        An output filename without extensions. The required
                        filename extension will be automatically determined
                        from an output format.
--raise-exceptions    If it is specified, raise exceptions.
-p PARSER, --parser PARSER
                        A maidenhair parser name which will be used to parse
                        the raw text data. If it is not specified, a parser
                        which was specified in a txt2xls configure file will
                        be used.
-l LOADER, --loader LOADER
                        A maidenhair loader name which will be used to load
                        the raw text data. If it is not specified, a parser
                        which was specified in a txt2xls configure file will
                        be used.
-a, --auto-unite      Automatically unite thedataset which filename middle
                        extensions have only integers. See "Filename middle
                        extensions" also.
--unite-basecolumn UNITE_BASECOLUMN
                        A column number which will be used to regulate data
                        regions for automatical unite. See `--auto` option
                        also.
-u USING, --using USING
                        A colon separated column number of the raw text data
                        which will be used to determine X and Y columns.
--relative            If it is True, the raw data will be converted to
                        relative data from the specified origin, based on the
                        specified column. See `--relative-origin` and
                        `--relative-basecolumn` also.
--relative-origin RELATIVE_ORIGIN
                        A dataset number which will be used as an orign of the
                        relative data. It is used with `--relative` option.
--relative-basecolumn RELATIVE_BASECOLUMN
                        A column number which will be used as a base column to
                        make the data relative. It is used with `--relative`
                        option.
--baseline BASELINE   If it is specified, the specified data file is used as
                        a baseline of the dataset. See `--baseline-column` and
                        `--baseline-function` also.
--baseline-column BASELINE_COLUMN
                        A column number which will be proceeded for baseline
                        regulation. It is used with `--baseline` option.
--baseline-function BASELINE_FUNCTION
                        A python code of a "lambda" function which is used to
                        determine the baseline value from the data. `columns`
                        and `column` variables are available in the code.