{ "info": { "author": "Timotej Kapus", "author_email": "kren1@users.noreply.github.com", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "A simple command line utility that sends your stdin to sheets.\n\nAvailable on pip by `pip install tosheets` (python3+ only)\n\n***NOTE:*** On first use, tosheets will open a browser window to authorize OAuth2 token.\n## Using `tosheets`\nPipe a local file to a new spreadsheet.\n```\ncat data.csv | tosheets -c A1 -d , --new-sheet=\"tosheetsSheet\"\n```\n\nPipe a local file to an existing spreadsheet:\n(Given a URL like `https://docs.google.com/spreadsheets/d/sample-spread-sheet-id-23sdf32543fs/edit#gid=0`)\n```\ncat data.csv | tosheets -c B4 -d , --spreadsheet=sample-spread-sheet-id-23sdf32543fs\n```\n\nSend sequence from 1 to 10 to a column starting at B4:\n```\nseq 1 10 | tosheets -c B4 --spreadsheet=sample-spread-sheet-id-23sdf32543fs\n```\n\nSend a matrix:\n```\n1 2\n3 4\n```\nTo the same location:\n\n```\necho -e '1 2\\n3 4' | tosheets -c B4 --spreadsheet=sample-spread-sheet-id-23sdf32543fs\n```\n\n\nTo sheets has a variety of other options listed:\n```\ntosheets, send stdin to your google sheets\n\nUsage:\n tosheets -c [-u] [-k] [-s ] [--spreadsheet=] [--new-sheet=] [-d ] [-q ]\n tosheets (-h | --help)\n tosheets --version\n\nOptions:\n -h --help Prints help.\n --version Show version.\n -i CSV Read this CSV instead of stdin\n -u Update CELL(s) instead of appending.\n -k Keep fields as they are (do not try to convert int or float).\n -c CELL Start appending to CELL.\n -s SHEET Use sheet name SHEET, otherwise tries to use\n TOSHEETS_SHEET (default: first visible sheet).\n -d DELIMITER Use DELIMITER to split each line (default: whitespace).\n -q QUOTE_CHAR A one-character string used to quote fields containing special characters,\n such as the delimiter or quotechar, or which contain new-line characters.\n (default: '\"').\n --spreadsheet= Send to the spreadsheet identified by spreadshetId\n (ie. docs.google.com/spreadsheets/d//...),\n if empty uses TOSHEETS_SPREADSHEET enviroment variable.\n --new-sheet= Create a new spreadsheet with the chosen name. Prints the\n spreadsheetId so it can be piped/stored.\n --open Open a browser with the newly created sheet\n```\n\n### Distribution\n```\npython setup.py sdist bdist_wheel\ntwine upload dist/*\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/kren1/tosheets", "keywords": "utility sheets command line", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "tosheets", "package_url": "https://pypi.org/project/tosheets/", "platform": "", "project_url": "https://pypi.org/project/tosheets/", "project_urls": { "Homepage": "https://github.com/kren1/tosheets" }, "release_url": "https://pypi.org/project/tosheets/0.4.2/", "requires_dist": [ "docopt", "oauth2client", "google-api-python-client" ], "requires_python": "", "summary": "Cmd utility that send stdin to google sheets", "version": "0.4.2" }, "last_serial": 5824674, "releases": { "0.1.8": [ { "comment_text": "", "digests": { "md5": "b35868edb1f20884bdfb94e28f837c54", "sha256": "08b7ea6ea7eb6ea40901c10d652a4d7a606a1a55e8f55b0736dc4361308848d1" }, "downloads": -1, "filename": "tosheets-0.1.8-py2-none-any.whl", "has_sig": false, "md5_digest": "b35868edb1f20884bdfb94e28f837c54", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 6719, "upload_time": "2017-11-17T13:36:20", "url": "https://files.pythonhosted.org/packages/ff/9d/8e5331a4ae3c43aacad216cf9ae7c149948decb8c8708da60ebfbe5baf6c/tosheets-0.1.8-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4cd21e71cebd8f6721bb145ab705a452", "sha256": "5f2dddfad52018004d558842c1c41300e3fd1a9190bde40f2ef7837a51f51676" }, "downloads": -1, "filename": "tosheets-0.1.8.tar.gz", "has_sig": false, "md5_digest": "4cd21e71cebd8f6721bb145ab705a452", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3711, "upload_time": "2017-11-17T13:36:22", "url": "https://files.pythonhosted.org/packages/64/70/fad19710a658ed116fee6ef9fa48e3d5e3a56c413c4f2209b32de0247e35/tosheets-0.1.8.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "87887bb18532d5816c7538e8961ca0a6", "sha256": "3583074395a1f4bd8b7cd7c57329a8c0ff8204e2743f063473f72499e4ea75cb" }, "downloads": -1, "filename": "tosheets-0.2.0-py2-none-any.whl", "has_sig": false, "md5_digest": "87887bb18532d5816c7538e8961ca0a6", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 7293, "upload_time": "2017-11-20T06:44:42", "url": "https://files.pythonhosted.org/packages/a6/8d/cdbb76dd0ac32c00e9aab019c8d4e398dc1089884ad2abf50eb08cd8259a/tosheets-0.2.0-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e4b67cbea6bc7fcc4c5189b3d94293d1", "sha256": "dc7f151c118fecf6f20729f099abb25dc871018ed825f98edcf6426dc161ab05" }, "downloads": -1, "filename": "tosheets-0.2.0.tar.gz", "has_sig": false, "md5_digest": "e4b67cbea6bc7fcc4c5189b3d94293d1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4170, "upload_time": "2017-11-20T06:44:45", "url": "https://files.pythonhosted.org/packages/cd/2a/f85f3b7128bd2a690985765330685efd2bc513d37f62f4dd8c4147ee34a3/tosheets-0.2.0.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "4cb277024dc1392c00041ef22e4a26e7", "sha256": "4490dcab68b461e685ab72d64a4db8f8f68e6d8371a72642dffd936d39d80691" }, "downloads": -1, "filename": "tosheets-0.3.0-py2-none-any.whl", "has_sig": false, "md5_digest": "4cb277024dc1392c00041ef22e4a26e7", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 7411, "upload_time": "2018-01-18T11:15:53", "url": "https://files.pythonhosted.org/packages/4e/64/8499528835dfbd528e492f99c1d41a17bd04118e92fc3674835e5aaba482/tosheets-0.3.0-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8de5d421fd37efa6d9123d2b2c619f54", "sha256": "adc149584b38cf795f5a28d6624820e97b76eb115983793adac5a32951ac9de3" }, "downloads": -1, "filename": "tosheets-0.3.0.tar.gz", "has_sig": false, "md5_digest": "8de5d421fd37efa6d9123d2b2c619f54", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4369, "upload_time": "2018-01-18T11:15:55", "url": "https://files.pythonhosted.org/packages/48/cf/af91acd0b1885569e17c5b77a49b73dbcd96c33595904cc61f610f9cf7a4/tosheets-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "2257e5170f4ced4928a5ea99db1a340b", "sha256": "0bf7096ab72ccdfcc35f33684cda6d4e0e2b4501c3f02a16d785de6b7d67d795" }, "downloads": -1, "filename": "tosheets-0.3.1-py3-none-any.whl", "has_sig": false, "md5_digest": "2257e5170f4ced4928a5ea99db1a340b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7086, "upload_time": "2018-06-04T22:12:15", "url": "https://files.pythonhosted.org/packages/4a/02/f2a1eee4da3f255f1ff2c16cc62cbe5f031e36fa1909efcf9e61cb995bc3/tosheets-0.3.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4d5d445eab804de2772860a86b3ddb61", "sha256": "4e28aaf233db83e8780477de046854701f1443d0d31d5202c1e1b3dd20a6e9d4" }, "downloads": -1, "filename": "tosheets-0.3.1.tar.gz", "has_sig": false, "md5_digest": "4d5d445eab804de2772860a86b3ddb61", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4468, "upload_time": "2018-06-04T22:12:17", "url": "https://files.pythonhosted.org/packages/3f/6b/a5c755f028b2f64768e7b0c88dd6d3f3e609b92c3961d8e876328bb0c876/tosheets-0.3.1.tar.gz" } ], "0.4.0": [ { "comment_text": "", "digests": { "md5": "0f7bc3f94f840aa5d62cc5ad01e5f46f", "sha256": "09778abfe6a7860bc30ed25ace8f285629703c7f393301781df43a537e0983c8" }, "downloads": -1, "filename": "tosheets-0.4.0-py2-none-any.whl", "has_sig": false, "md5_digest": "0f7bc3f94f840aa5d62cc5ad01e5f46f", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 7898, "upload_time": "2019-03-01T10:25:26", "url": "https://files.pythonhosted.org/packages/24/3e/347409f6c9658b60fc4a3c7d3ee59577c63fa3e1a8bff29051178add32f4/tosheets-0.4.0-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1bfbd855011f57236384a1b78e1e912d", "sha256": "0bcc386691e122271962d4a9e0403ce6c1acc55691a4e05ba71d5676f97d13ca" }, "downloads": -1, "filename": "tosheets-0.4.0.tar.gz", "has_sig": false, "md5_digest": "1bfbd855011f57236384a1b78e1e912d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4549, "upload_time": "2019-03-01T10:25:27", "url": "https://files.pythonhosted.org/packages/7f/87/7e2ea970f42c7358fd63dc119abd9d066d3853c74ce39185aa87d5c9dbec/tosheets-0.4.0.tar.gz" } ], "0.4.1": [ { "comment_text": "", "digests": { "md5": "c694225de537a973f43911d5fd194949", "sha256": "51bafe119e067ebbf809200ceb4c4e4f5d9b1ca4c901534759445074cf097a51" }, "downloads": -1, "filename": "tosheets-0.4.1-py2-none-any.whl", "has_sig": false, "md5_digest": "c694225de537a973f43911d5fd194949", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 7921, "upload_time": "2019-03-01T10:48:16", "url": "https://files.pythonhosted.org/packages/ac/4f/2878affd0a1e8f91ee0af1d36994d2ac17e9f44ff274f8a6aa39fa28f792/tosheets-0.4.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "43181ed9adb472310fce75c1f5cfb5ec", "sha256": "c61f26a03d3f90ea496f5b09f2d2e247b6fec2d4654b19421e3c1d0eb781e335" }, "downloads": -1, "filename": "tosheets-0.4.1.tar.gz", "has_sig": false, "md5_digest": "43181ed9adb472310fce75c1f5cfb5ec", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4565, "upload_time": "2019-03-01T10:48:18", "url": "https://files.pythonhosted.org/packages/8a/b2/2568a655db5a14a72e11ccb191e63d80d5fe2ae2db617e79bffd8bc44840/tosheets-0.4.1.tar.gz" } ], "0.4.2": [ { "comment_text": "", "digests": { "md5": "226e517fea16f82a1dab6874aa1c829a", "sha256": "452bd203f688003b327e96c23a67de00db4e39d1886351b2cd95bd53cf599f3f" }, "downloads": -1, "filename": "tosheets-0.4.2-py3-none-any.whl", "has_sig": false, "md5_digest": "226e517fea16f82a1dab6874aa1c829a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6594, "upload_time": "2019-09-13T09:32:03", "url": "https://files.pythonhosted.org/packages/b5/e3/c92757a0a38126bb5b7245b3db2c1039b1f7eef73e77c8d05864ab8b2726/tosheets-0.4.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9eb58e2457bdf966998d115f59a83c20", "sha256": "4bbe615dfc1ea3974417f14cf6a36ab8d20311abf75991fbad9aa2e8825a1d4b" }, "downloads": -1, "filename": "tosheets-0.4.2.tar.gz", "has_sig": false, "md5_digest": "9eb58e2457bdf966998d115f59a83c20", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4759, "upload_time": "2019-09-13T09:32:25", "url": "https://files.pythonhosted.org/packages/2e/7d/e82e61664868b6062b9b92f9333cf569a5fe6bfb9764a2f0bd74940d6e26/tosheets-0.4.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "226e517fea16f82a1dab6874aa1c829a", "sha256": "452bd203f688003b327e96c23a67de00db4e39d1886351b2cd95bd53cf599f3f" }, "downloads": -1, "filename": "tosheets-0.4.2-py3-none-any.whl", "has_sig": false, "md5_digest": "226e517fea16f82a1dab6874aa1c829a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6594, "upload_time": "2019-09-13T09:32:03", "url": "https://files.pythonhosted.org/packages/b5/e3/c92757a0a38126bb5b7245b3db2c1039b1f7eef73e77c8d05864ab8b2726/tosheets-0.4.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9eb58e2457bdf966998d115f59a83c20", "sha256": "4bbe615dfc1ea3974417f14cf6a36ab8d20311abf75991fbad9aa2e8825a1d4b" }, "downloads": -1, "filename": "tosheets-0.4.2.tar.gz", "has_sig": false, "md5_digest": "9eb58e2457bdf966998d115f59a83c20", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4759, "upload_time": "2019-09-13T09:32:25", "url": "https://files.pythonhosted.org/packages/2e/7d/e82e61664868b6062b9b92f9333cf569a5fe6bfb9764a2f0bd74940d6e26/tosheets-0.4.2.tar.gz" } ] }