exv 1.0.2

View Excel files in the terminal

exv: a simple Excel file viewer for the command line

Command line tool for viewing Excel files.

The module openpyxl is 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 dealt with.

Usage

The basic usage is exv <excelfile> [<worksheet>]. If the given excel 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