View Excel files in the terminal
Project description
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 bytabulate
, 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
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.