Metadata-Version: 1.1
Name: tosheets
Version: 0.2.0
Summary: Cmd utility that send stdin to google sheets
Home-page: https://github.com/kren1/tosheets
Author: Timotej Kapus
Author-email: kren1@users.noreply.github.com
License: MIT
Description: A simple command line utility that sends your stdin to sheets.
        
        Available on pip by `pip install tosheets` (python3+ only)
        
        ***NOTE:***  On first use, tosheets will open a browser window to authorize OAuth2 token.
        ## Using `tosheets`
        
        Given a google sheets spreadsheet `https://docs.google.com/spreadsheets/d/sample-spread-sheet-id-23sdf32543fs/edit#gid=0`
        
        You can send stdin to the spreadsheet. For example to send sequence from 1 to 10 to a column starting at B4:
        
        ```
        seq 1 10 | tosheets -c B4 --spreadsheet sample-spread-sheet-id-23sdf32543fs
        ```
        
        Alternatively to send a matrix 
        
        ```
        1 2
        3 4
        ```
        To the same location:
        
        ```
        echo -e '1 2\n3 4' | tosheets -c B4 --spreadsheet=1xF8oFP-QYgPV0AF0dzYSQe9PYj6BWlLanh_0Vc33JFc
        ```
        
        
        To sheets has a variety of other options listed:
        ```
        tosheets, send stdin to your google sheets
        
        Usage:
          tosheets -c <cell> [-u] [-s <sheet>] [--spreadsheet=<spreadsheet>] [--new-sheet=<name>] [-d <delimiter>]
          tosheets (-h | --help)
          tosheets --version
        
        Options:
          -h --help                     Prints help.
          --version                     Show version.
          -u                            Update CELL(s) instead of appending.
          -c CELL                       Start appending to CELL.
          -s SHEET                      Use sheet name SHEET, otherwise tries to use
                                        TOSHEETS_SHEET (default: first visible sheet).
          -d DELIMITER                  Use DELIMITER to split each line (default: whitespace).
          --spreadsheet=<spreadsheet>   Send to the spreadsheet identified by spreadshetId
                                        (ie. docs.google.com/spreadsheets/d/<spreadsheetId>/...),
                                        if empty uses TOSHEETS_SPREADSHEET enviroment variable.                              
          --new-sheet=<name>            Create a new spreadsheet with the chosen name. Prints the
                                        spreadsheetId so it can be piped/stored.
        ```
        
        ### Distribution
        ```
        python setup.py sdist bdist_wheel
        twine upload dist/*
        ```
        
Keywords: utility sheets command line
Platform: UNKNOWN
Classifier: Intended Audience :: Developers
Classifier: Natural Language :: English
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
