v0.5.x

>>> import snapsheets as ss
>>> url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
>>> sheet = ss.Sheet(url=url, desc="Get Sample Sheet")
>>> sheet.snapshot()
📣 Get Sample Sheet
🤖 Downloaded snapd/snapsheet.xlsx
🚀 Renamed to snapd/20210412T104926_snapsheet.xlsx

CLI

  • Added command line interface

$ snapsheets -h
usage: snapsheets [-h] [--config CONFIG] [--url URL] [-v]

optional arguments:
-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
-v, --version    show version

With --url option

  • Copy and paste the URL of Google spreadsheet

$ snapsheets --url https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0
📣 snapsheet
🤖 Downloaded snapd/snapsheet.xlsx
🚀 Renamed to snapd/20210412T104926_snapsheet.xlsx

With no argument

  • Load from configuration file

$ snapsheets
ic| 'Loaded TOML files: ', n: 2
ic| 'Loaded TOML files: ', fname: PosixPath('config/gsheet.toml')
ic| 'Loaded TOML files: ', fname: PosixPath('config/snapsheets.toml')
ic| 'Add sheet', name: 'toml_sample1'
ic| 'Add sheet', name: 'toml_sample2'
📣 Example for Snapshot module (in TOML)
🤖 Downloaded snapd/snapsheet.xlsx
🚀 Renamed to snapd/2021_toml_sample1.xlsx
📣 20210304_storage_comparison
🤖 Downloaded snapd/snapsheet.xlsx
🚀 Renamed to snapd/20210412_toml_sample2.xlsx

Show version

$ snapsheets -v
0.5.1