View Excel files in the terminal
Project description
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 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.