texel - Command line interface for reading spreadsheets inside terminal

Overview

texel - Command line interface for reading spreadsheets inside terminal.

Sometimes, you have to deal with spreadsheets. Those are sad times. Fortunately there is texel!

Texel is a useful CLI for quickly reading spreadsheets and copying their contents to clipboard in CSV format.

texel in action

Usage

texel [-h] [-d DELIMITER] [-c CELLWIDTH] [-p PRECISION]
             [--fillna FILLNA]
             FILE

positional arguments:
  FILE                  Spreadsheet path (csv, xls, xlsx, xlsm,
                        xlsb, odf, ods or odt)

optional arguments:
  -h, --help            show this help message and exit
  -d DELIMITER, --delimiter DELIMITER
                        Delimiter for csv files
  -c CELLWIDTH, --cellwidth CELLWIDTH
                        Width of a cell
  -p PRECISION, --precision PRECISION
                        Precision of floating point numbers
  --fillna FILLNA       Value to use to fill holes in the
                        spreadsheet

Commands

  • ⬆️ ⬇️ ⬅️ ➡️ / kjhl - Move
  • /n - Switch sheet
  • v - Visual/selection mode
  • - Exit visual/selection mode
  • c / y - Copy selected cell(s)
  • q - Exit

Supported file formats:

  • xlsx
  • xls
  • xlsm
  • xlsb
  • csv
  • odt
  • odf
  • ods

Installation

$ pip install texel

Licence

MIT

You might also like...
A command line interface to buy things in stregsystemet

Stregsystemet-CLI This repository is the Stregsystemet CLI, to buy things in Stregsystemet, at AAU. Use of this cli-tool is at your own risk and there

moviepy-cli: Command line interface for MoviePy.

Moviepy-cli is designed to apply several video editing in a single command with Moviepy as an alternative to Video-cli.

Command line interface for unasync
Command line interface for unasync

CLI for unasync Command line interface for unasync Getting started Install Run the following command to install the package with pip: pip install unas

Rover is a command line interface application that allows through browse through mission data, images, metadata from the NASA Official Website

🤖 rover Rover is a command line interface application that allows through browse through mission data, images, metadata from the NASA Official Websit

bsp_tool provides a Command Line Interface for analysing .bsp files

bsp_tool Python library for analysing .bsp files bsp_tool provides a Command Line Interface for analysing .bsp files Current development is focused on

Investing library and command-line interface inspired by the Bogleheads philosophy
Investing library and command-line interface inspired by the Bogleheads philosophy

Lakshmi (Screenshot of the lak command in action) Background This project is inspired by Bogleheads forum. Bogleheads focus on a simple but powerful p

⚙ A lightweight command line interface library for creating commands.
⚙ A lightweight command line interface library for creating commands.

⚙ A lightweight command line interface library for creating cli commands. About | Installation | Usage | Features | Contributors | License About Next:

Command-line interface to PyPI Stats API to get download stats for Python packages
Command-line interface to PyPI Stats API to get download stats for Python packages

pypistats Python 3.6+ interface to PyPI Stats API to get aggregate download statistics on Python packages on the Python Package Index without having t

A minimal and ridiculously good looking command-line-interface toolkit.
A minimal and ridiculously good looking command-line-interface toolkit.

Pyceo Pyceo is a Python package for creating beautiful, composable, and ridiculously good looking command-line-user-interfaces without having to write

Comments
  • moving around in header can crash app

    moving around in header can crash app

    When I use the keyboard to move quickly past the left edge of the screen in the Header column or moving to the right only a few cells, also in the header, can crash the app.

    Awesome app. Thanks!

    Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.9/bin/texel", line 8, in sys.exit(main()) File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/texel/texel.py", line 66, in main curses.wrapper(run, sheets, args) File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/curses/init.py", line 94, in wrapper return func(stdscr, *args, **kwds) File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/texel/texel.py", line 17, in run while grid.handle_press(scr.getch()): File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/texel/grid.py", line 45, in handle_press self.actionskey File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/texel/grid.py", line 38, in runnable self.draw() File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/texel/grid.py", line 175, in draw self.draw_footer() File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/texel/grid.py", line 163, in draw_footer self.scr.addstr( _curses.error: addwstr() returned ERR

    opened by theconsultant 2
  • open xls file fail

    open xls file fail

    Traceback (most recent call last): File "/home/.../.local/bin/texel", line 8, in sys.exit(main()) File "/home/.../.local/lib/python3.6/site-packages/texel/texel.py", line 66, in main curses.wrapper(run, sheets, args) File "/usr/lib64/python3.6/curses/init.py", line 94, in wrapper return func(stdscr, *args, **kwds) File "/home/.../.local/lib/python3.6/site-packages/texel/texel.py", line 15, in run Styles(args.cellwidth, args.precision), File "/home/.../.local/lib/python3.6/site-packages/texel/styles.py", line 20, in init self.init_colors() File "/home/.../.local/lib/python3.6/site-packages/texel/styles.py", line 37, in init_colors curses.init_pair(6, C.LIGHT_MAGENTA, C.BLACK) _curses.error: init_pair() returned ERR

    opened by ruizgo 2
  • Pressing almost any key crashes the program

    Pressing almost any key crashes the program

    As the title says, pressing any key apart from Tab, Shift-Tab, h/j/k/l, arrows, c/y, v, q crashes the application:

    Traceback (most recent call last):
      File "/home/.../.local/bin/texel", line 8, in <module>
        sys.exit(main())
      File "/home/.../.local/lib/python3.10/site-packages/texel/texel.py", line 66, in main
        curses.wrapper(run, sheets, args)
      File "/usr/lib64/python3.10/curses/__init__.py", line 94, in wrapper
        return func(stdscr, *args, **kwds)
      File "/home/.../.local/lib/python3.10/site-packages/texel/texel.py", line 17, in run
        while grid.handle_press(scr.getch()):
      File "/home/.../.local/lib/python3.10/site-packages/texel/grid.py", line 46, in handle_press
        elif key == Keys.QUIT:
      File "/home/.../.local/lib/python3.10/site-packages/texel/keys.py", line 11, in __eq__
        return self._hash == other._hash
    AttributeError: 'NoneType' object has no attribute '_hash'
    

    It would be better to do nothing or write "command not supported in a status line", and maybe implement the command ? that summarizes the available keybindings.

    opened by FedericoStra 1
Releases(v0.2.0)
CLabel is a terminal-based cluster labeling tool that allows you to explore text data interactively and label clusters based on reviewing that data.

CLabel is a terminal-based cluster labeling tool that allows you to explore text data interactively and label clusters based on reviewing that

Peter Baumgartner 29 Aug 09, 2022
Bringing emacs' greatest feature to neovim - Tetris!

nvim-tetris Bringing emacs' greatest feature to neovim - Tetris! This plugin is written in Fennel using Olical's project Aniseed for creating the proj

129 Dec 26, 2022
Albert launcher extension for converting units of length, mass, speed, temperature, time, current, luminosity, printing measurements, molecular substance, and more

unit-converter-albert-ext Extension for converting units of length, mass, speed, temperature, time, current, luminosity, printing measurements, molecu

Jonah Lawrence 2 Jan 13, 2022
PdpCLI is a pandas DataFrame processing CLI tool which enables you to build a pandas pipeline from a configuration file.

PdpCLI Quick Links Introduction Installation Tutorial Basic Usage Data Reader / Writer Plugins Introduction PdpCLI is a pandas DataFrame processing CL

Yasuhiro Yamaguchi 15 Jan 07, 2022
A Telegram Bot Written In Python To Upload Medias To telegra.ph

Telegraph-Uploader A Telegram Bot Written In Python To Upload Medias To telegra.ph DEPLOY YOU CAN SIMPLY DEPLOY ON HEROKU BY CLICKING THE BUTTON BELOW

Rithunand 31 Dec 03, 2022
A simple CLI based any Download Tool, that find files and let you stream or download thorugh WebTorrent CLI or Aria or any command tool

Privateer A simple CLI based any Download Tool, that find files and let you stream or download thorugh WebTorrent CLI or Aria or any command tool How

Shreyash Chavan 2 Apr 04, 2022
Personal and work vim 8 configuration with submodules

vimfiles Windows Vim 8 configuration files based on the recommendations of Ruslan Osipov, Keep Your vimrc file clean and The musings of bluz71. :help

1 Aug 27, 2022
CmdTube is a Python CLI library for searching, downloading, and watching YouTube tutorials

CmdTube is a Python CLI library for searching, downloading, and watching YouTube tutorials. This library was made with programmers in mind and it's dedicated to every programmer who watches YouTube v

Samuel Ayomide Ogunleke 2 Aug 22, 2022
WA Terminal is a CLI application that allows us to login and send message with WhatsApp with a single command.

WA Terminal is a CLI application that allows us to login and send message with WhatsApp with a single command.

Aziz Fikri 15 Apr 15, 2022
Set of scripts & tools for converting between numbers and major system encoded words.

major-system-converter Set of scripts & tools for converting between numbers and major system encoded words. Uses phonetics instead of letters to conv

4 Aug 09, 2022
Simple Python Library to display text with color in Python Terminal

pyTextColor v1.0 Introduction pyTextColor is a simple Python Library to display colorful outputs in Terminal, etc. Note: Your Terminal or any software

Siddhesh Chavan 1 Jan 23, 2022
🕰 The command line tool for scheduling Python scripts

hickory is a simple command line tool for scheduling Python scripts.

Max Humber 146 Dec 07, 2022
inklayers is a command line program that exports layers from an SVG file.

inklayers is a command line program that exports layers from an SVG file. It can be used to create slide shows by editing a single SVG file.

11 Mar 29, 2022
Use case: quick JSON processing/restructuring with jq without terminal

alfred-jq Alfred workflow to conveniently process JQ on clipboard based on a jq query Also available at: packal/jq Use case: quick JSON processing/res

T on Meta Mode 5 Sep 30, 2022
Command Line Manager + Interactive Shell for Python Projects

Manage Command Line Manager + Interactive Shell for Python Projects

Python Manage 123 Aug 28, 2022
A simple cli utility for importing or exporting dashboard json definitions using the Grafana HTTP API.

P4CMD 🌴 A Python Perforce package that doesn't bring in any other packages to work. Relies on p4cli installed on the system. p4cmd The p4cmd module h

Beam Connectivity 31 Jan 06, 2023
GanTTY - Project planning from the terminal

GanTTY - Project planning from the terminal

Timeo Sam Pochin 161 Dec 26, 2022
Browse Hacker News like a haxor: A Hacker News command line interface (CLI).

haxor-news Coworker who sees me looking at something in a browser: "Glad you're not busy; I need you to do this, this, this..." Coworker who sees me s

Donne Martin 3.8k Jan 07, 2023
Easily turn single threaded command line applications into a fast, multi-threaded application with CIDR and glob support.

Easily turn single threaded command line applications into a fast, multi-threaded application with CIDR and glob support.

Michael Skelton 1k Jan 07, 2023
A webmining CLI tool & library for python.

minet is a webmining command line tool & library for python (= 3.6) that can be used to collect and extract data from a large variety of web sources

médialab Sciences Po 165 Dec 17, 2022