# Snapsheets
Getting tired of downloading Google Spreadsheets one by one from the browser ?
This package enables to wget Google Spreadsheets without login.
(Spreadsheets should be shared with public link)
---
# Install
```bash
$ pip3 install snapsheets
```
# Usage
```bash
$ snapsheets --url="copy_and_paste_url_here"
2022-06-09T08:09:31 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:09:31 | SUCCESS | 🚀 Renamed to snapd/20220609T080931_snapsheet.xlsx
```
# Docs and Repository
- GitLab Pages : https://qumanote.gitlab.io/snapsheets/
- GitLab Repos : https://gitlab.com/qumanote/snapsheets/
- PyPI package : https://pypi.org/project/snapsheets/
# Help
```bash
$ snapsheets -h
usage: snapsheets [-h] [--config CONFIG] [--url URL] [--debug] [--version]
options:
-h, --help show this help message and exit
--config CONFIG set config directory (default: ./config/)
--url URL copy and paste an URL of the Google spreadsheet
--debug show more messages
--version show program's version number and exit
```
- Use ``--url`` option to download single spreadsheet.
- Use ``--config`` option to download multiple spreadsheets.
- create a directory for config files.
- create a config file in TOML format.
# Examples
## with ``--url`` option
```bash
$ snapsheets --url="https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
2022-06-09T08:09:31 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:09:31 | SUCCESS | 🚀 Renamed to snapd/20220609T080931_snapsheet.xlsx
```
- Downloaded file is temporarily named as ``snapsheet.xlsx``, then renamed with current-time based prefix.
## with ``--config`` option
```bash
$ snapsheets --config="config/"
2022-06-09T08:05:48 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:05:48 | SUCCESS | 🚀 Renamed to snapd/2022_toml_sample1.xlsx
2022-06-09T08:05:49 | SUCCESS | 🤖 Downloaded snapd/snapsheet.xlsx
2022-06-09T08:05:49 | SUCCESS | 🚀 Renamed to snapd/20220609_toml_sample3.csv
```
- Make ``./config/`` directory and place your TOML files.
- If ``./config/`` does not exist, it will search from ``. (current directory)``.
- Downloaded files are saved to ``./snapd/`` directory
- If ``./snapd/`` does not exit, it will be saved in ``. (current directory)``.
## with module ``import``
```python
>>> from snapsheets import Sheet
>>> url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
>>> sheet = Sheet(url=url, desc="Get Sample Sheet")
>>> sheet.snapshot()
📣 Get Sample Sheet
🤖 Downloaded snapd/snapsheet.xlsx
🚀 Renamed to snapd/20220602T225044_snapsheet.xlsx
```
---
# Other requirements
- Install ``wget`` if your system doesn't have them
- Make your spreadsheet available with shared link (OK with read-only)
Raw data
{
"_id": null,
"home_page": "https://qumasan.gitlab.io/snapsheets/",
"name": "snapsheets",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.10,<4.0",
"maintainer_email": "",
"keywords": "wget,googlesheet",
"author": "shotakaha",
"author_email": "shotakaha+py@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/6c/c4/8615db6002b11eee196846c8c20a7a83212903a6cf1a523fbc466c805859/snapsheets-0.6.6.tar.gz",
"platform": null,
"description": "\n\n\n\n\n\n# Snapsheets\n\nGetting tired of downloading Google Spreadsheets one by one from the browser ?\n\nThis package enables to wget Google Spreadsheets without login.\n(Spreadsheets should be shared with public link)\n\n---\n\n# Install\n\n```bash\n$ pip3 install snapsheets\n```\n\n# Usage\n\n```bash\n$ snapsheets --url=\"copy_and_paste_url_here\"\n2022-06-09T08:09:31 | SUCCESS | \ud83e\udd16 Downloaded snapd/snapsheet.xlsx\n2022-06-09T08:09:31 | SUCCESS | \ud83d\ude80 Renamed to snapd/20220609T080931_snapsheet.xlsx\n```\n\n# Docs and Repository\n\n- GitLab Pages : https://qumanote.gitlab.io/snapsheets/\n- GitLab Repos : https://gitlab.com/qumanote/snapsheets/\n- PyPI package : https://pypi.org/project/snapsheets/\n\n\n\n\n\n# Help\n\n```bash\n$ snapsheets -h\nusage: snapsheets [-h] [--config CONFIG] [--url URL] [--debug] [--version]\n\noptions:\n -h, --help show this help message and exit\n --config CONFIG set config directory (default: ./config/)\n --url URL copy and paste an URL of the Google spreadsheet\n --debug show more messages\n --version show program's version number and exit\n```\n\n- Use ``--url`` option to download single spreadsheet.\n- Use ``--config`` option to download multiple spreadsheets.\n - create a directory for config files.\n - create a config file in TOML format.\n\n# Examples\n\n## with ``--url`` option\n\n```bash\n$ snapsheets --url=\"https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0\"\n2022-06-09T08:09:31 | SUCCESS | \ud83e\udd16 Downloaded snapd/snapsheet.xlsx\n2022-06-09T08:09:31 | SUCCESS | \ud83d\ude80 Renamed to snapd/20220609T080931_snapsheet.xlsx\n```\n\n- Downloaded file is temporarily named as ``snapsheet.xlsx``, then renamed with current-time based prefix.\n\n## with ``--config`` option\n\n```bash\n$ snapsheets --config=\"config/\"\n2022-06-09T08:05:48 | SUCCESS | \ud83e\udd16 Downloaded snapd/snapsheet.xlsx\n2022-06-09T08:05:48 | SUCCESS | \ud83d\ude80 Renamed to snapd/2022_toml_sample1.xlsx\n2022-06-09T08:05:49 | SUCCESS | \ud83e\udd16 Downloaded snapd/snapsheet.xlsx\n2022-06-09T08:05:49 | SUCCESS | \ud83d\ude80 Renamed to snapd/20220609_toml_sample3.csv\n```\n\n- Make ``./config/`` directory and place your TOML files.\n - If ``./config/`` does not exist, it will search from ``. (current directory)``.\n- Downloaded files are saved to ``./snapd/`` directory\n - If ``./snapd/`` does not exit, it will be saved in ``. (current directory)``.\n\n## with module ``import``\n\n```python\n>>> from snapsheets import Sheet\n>>> url = \"https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0\"\n>>> sheet = Sheet(url=url, desc=\"Get Sample Sheet\")\n>>> sheet.snapshot()\n\ud83d\udce3 Get Sample Sheet\n\ud83e\udd16 Downloaded snapd/snapsheet.xlsx\n\ud83d\ude80 Renamed to snapd/20220602T225044_snapsheet.xlsx\n```\n\n---\n\n# Other requirements\n\n- Install ``wget`` if your system doesn't have them\n- Make your spreadsheet available with shared link (OK with read-only)\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Getting tired of downloading Google Spreadsheets one by one from the browser ?",
"version": "0.6.6",
"project_urls": {
"Homepage": "https://qumasan.gitlab.io/snapsheets/",
"Repository": "https://gitlab.com/qumasan/snapsheets/"
},
"split_keywords": [
"wget",
"googlesheet"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "464e66a0c02313b7aa9adbf347ef7d207810c3b00a14b2d585530b5d2b3da765",
"md5": "7df838c27699e03fec2034cb6e02b6de",
"sha256": "62dbffba4fe1c1fec329015e2d6c7c6483c67c1acca9da62911b1cd652866371"
},
"downloads": -1,
"filename": "snapsheets-0.6.6-py3-none-any.whl",
"has_sig": false,
"md5_digest": "7df838c27699e03fec2034cb6e02b6de",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.10,<4.0",
"size": 17706,
"upload_time": "2023-12-29T07:25:06",
"upload_time_iso_8601": "2023-12-29T07:25:06.454251Z",
"url": "https://files.pythonhosted.org/packages/46/4e/66a0c02313b7aa9adbf347ef7d207810c3b00a14b2d585530b5d2b3da765/snapsheets-0.6.6-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "6cc48615db6002b11eee196846c8c20a7a83212903a6cf1a523fbc466c805859",
"md5": "5188c41663fd700de01f9a786a59589a",
"sha256": "b06324f9c2bab86bbf16782fefdaa803b423123586d69304bbcfd9b8d1558029"
},
"downloads": -1,
"filename": "snapsheets-0.6.6.tar.gz",
"has_sig": false,
"md5_digest": "5188c41663fd700de01f9a786a59589a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.10,<4.0",
"size": 14379,
"upload_time": "2023-12-29T07:25:08",
"upload_time_iso_8601": "2023-12-29T07:25:08.661217Z",
"url": "https://files.pythonhosted.org/packages/6c/c4/8615db6002b11eee196846c8c20a7a83212903a6cf1a523fbc466c805859/snapsheets-0.6.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-12-29 07:25:08",
"github": false,
"gitlab": true,
"bitbucket": false,
"codeberg": false,
"gitlab_user": "qumasan",
"gitlab_project": "snapsheets",
"lcname": "snapsheets"
}
JSON