https://github.com/arvestad/exv
Command line tool for viewing Excel files
Science Score: 26.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
○CITATION.cff file
-
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (9.5%) to scientific vocabulary
Repository
Command line tool for viewing Excel files
Basic Info
- Host: GitHub
- Owner: arvestad
- License: gpl-3.0
- Language: Python
- Default Branch: main
- Size: 195 KB
Statistics
- Stars: 2
- Watchers: 1
- Forks: 0
- Open Issues: 0
- Releases: 5
Metadata Files
README.md
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.
No attempt is made to make 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/Libre 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.
Install
Recommended installation is:
pip install --upgrade pip
pip install exv
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 threesheets.xlsx Available sheets: fib harmonic euclid $ exv threesheets.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
Owner
- Name: Lars Arvestad
- Login: arvestad
- Kind: user
- Location: Kräftriket, Stockholm
- Company: Stockholm University
- Website: https://www.su.se/english/profiles/arve-1.232358
- Repositories: 16
- Profile: https://github.com/arvestad
GitHub Events
Total
- Issues event: 1
- Watch event: 2
- Push event: 1
Last Year
- Issues event: 1
- Watch event: 2
- Push event: 1
Packages
- Total packages: 1
-
Total downloads:
- pypi 42 last-month
- Total dependent packages: 0
- Total dependent repositories: 0
- Total versions: 6
- Total maintainers: 1
pypi.org: exv
View Excel files in the terminal
- Documentation: https://exv.readthedocs.io/
- License: GNU General Public License v3 (GPLv3)
-
Latest release: 1.0.2
published about 2 years ago