v0.6.0 (in development)

Organizing classes : Sheet and Book
Add snapsheets-next command
Changed items in configuration
Keep snapsheets command (will be deprecated)

CLI

snapsheets

$ 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

snapsheets-next

$ snapsheets-next -h
usage: snapsheets-next [-h] [--config config | --url url] [-o filename] [-d description] [-t format] [--skip] [--debug] [--version]

snapsheets

options:
  -h, --help       show this help message and exit
  --config config  set config file or directory
  --url url        set URL of Google spreadsheet
  -o filename      set output filename
  -d description   set description of a spreadsheet
  -t format        set datetime prefix for backup filename
  --skip           skip file
  --debug          show more messages
  --version        show program's version number and exit

Show version

$ snapsheets --version
0.5.7
$ snapsheets-next --version
0.6.4

Configurations

config.toml or config/*.toml will be loaded if you create an instance without any argument.
You can change the filename/directory.

Supported Format

#. TOML #. YAMML

Supported Sections

sheets
- url : copy and paste an URL of the Google spreadsheet
- filename : downloaded filename
- desc : description for you not to forget
- datefmt : used as prefix of downloaded filename
- skip : set true if you wanna skip downloading (default: false)

config/snapsheets.toml

[tool.snapsheets]
datefmt = "%Y%m%dT%H%M%S"

[tool.snapsheets.volumes]
saved = "./snapd/"
logd = "./varlogs/"
logf = "snapsheets.log"

[tool.snapsheets.options]
wget = "--quiet"

config/gsheet.toml

[sheets]

[sheets.toml_sample1]
name = "toml_sample1"
desc = "Sample1 : A spreadsheet for snapsheets (in TOML)"
url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
format = "xlsx"
datefmt = "%Y"
skip = false

[sheets.toml_sample2]
name = "toml_sample2"
desc = "Sample2 : A spreadsheet for snapsheets (in TOML)"
url = "https://docs.google.com/spreadsheets/d/16Sc_UgShNuxMfRnBiFsjmfThE1VfVhJf3jgmxNvFeEI/edit#gid=2015536778"
format = "csv"
datefmt = "%Y%m%d"
skip = true

[sheets.toml_sample3]
name = "toml_sample3"
desc = "Sample3: A spreadsheet for snapsheets (in TOML)"
url = "https://docs.google.com/spreadsheets/d/16Sc_UgShNuxMfRnBiFsjmfThE1VfVhJf3jgmxNvFeEI/edit#gid=2015536778"
format = "csv"
datefmt = "%Y%m%d"
skip = false

TOML Examples

sandbox/next.toml

[[sheets]]
url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=01NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM"
filename = "test_data/toml_sample1.xlsx"
description = "Example for Snapshot module (in TOML)"
datefmt = "%Y"
skip = false

[[sheets]]
url = "https://docs.google.com/spreadsheets/d/16Sc_UgShNuxMfRnBiFsjmfThE1VfVhJf3jgmxNvFeEI/edit#gid=0"
filename = "snapd/toml_sample2.csv"
desc = "20210304_storage_comparison"
datefmt = "%Y%m%d"
skip = false

YAML Examples

sandbox/next.yaml

sheets:
  - url:  "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=01NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM"
    filename: "test_data/toml_sample1.xlsx"
    description: "Example for Snapshot module (in TOML)"
    datefmt: "%Y"
    skip: false
  - url: "https://docs.google.com/spreadsheets/d/16Sc_UgShNuxMfRnBiFsjmfThE1VfVhJf3jgmxNvFeEI/edit#gid=0"
    filename: "snapd/toml_sample2.csv"
    desc: "20210304_storage_comparison"
    datefmt: "%Y%m%d"
    skip: false