Metadata-Version: 2.1
Name: exv
Version: 1.2
Summary: View Excel files in the terminal
Author-email: Lars Arvestad <arve@math.su.se>
License: GNU General Public License v3 (GPLv3)
Project-URL: homepage, http://github.com/arvestad/exv
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: GNU General Public License v3 (GPLv3)
Classifier: Operating System :: OS Independent
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: tabulate
Requires-Dist: openpyxl >3.0
Requires-Dist: xlrd >2.0
Requires-Dist: odsparsator >1.1

# exv:  a simple Excel file viewer for the command line

Command line tool for viewing spreadsheets files, including Excel (.xls, .xlsx), Open Office (.ods), and similar.

The modules `openpyxl`, `xlrd`, and `odsparsator` are used for parsing and interpretation of the input files,
and `tabulate` is used for viewing worksheets in a tabular fashion.

Formulas are handled, but no attempt is made at making use of embedded charts and other non-tabular objects.
In fact, nothing fancy has been dealt with. Formulas are not coming out very well from Open Office files.

## Usage

The basic usage is `exv <spreadsheet> [<worksheet>]`. If the given spreadsheet file has a single worksheet, then the worksheet is viewed.
A list of worksheet names are given if there is more than one worksheet defined in the file. You can give a format argument
to have the sheet displayed in a special way. 

### Example

```
$ exv single.xlsx
0  n  fib(n)
1  0  0
2  1  1
3  2  1
4  3  2
5  4  3
6  5  5
7  6  8

$ exv -f github single.xlsx
|---|---|--------|
| 0 | n | fib(n) |
| 1 | 0 | 0      |
| 2 | 1 | 1      |
| 3 | 2 | 1      |
| 4 | 3 | 2      |
| 5 | 4 | 3      |
| 6 | 5 | 5      |
| 7 | 6 | 8      |

$ exv three_sheets.xlsx
Available sheets:
fib
harmonic
euclid
$ exv three_sheets.xlsx harmonic
0  n  harmonic(n)
1  1  1
2  2  1.5
3  3  1.8333333333333333
4  4  2.083333333333333
5  5  2.283333333333333
6  6  2.4499999999999997
```

### Options

+ `-h`, `--help` -- Show basic usage.
+ `-nr`, `--no-row-numbers` -- suppress an initial column with row numbers.
+ `-f`, `--format` -- Choose from a large number of output formats. These are formats implemented by `tabulate`, see list below.
+ `--version` -- Show version number.

### Output formats

+ asciidoc
+ double_grid
+ double_outline
+ fancy_grid
+ fancy_outline
+ github
+ grid
+ heavy_grid
+ heavy_outline
+ html
+ jira
+ latex
+ latex_booktabs
+ latex_longtable
+ latex_raw
+ mediawiki
+ mixed_grid
+ mixed_outline
+ moinmoin
+ orgtbl
+ outline
+ pipe
+ plain
+ presto
+ pretty
+ psql
+ rounded_grid
+ rounded_outline
+ rst
+ simple
+ simple_grid
+ simple_outline
+ textile
+ tsv
+ unsafehtml
+ youtrack
