v0.4.x

>>> import snapsheets as ss
>>> sample_url1 = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
>>> sheet = ss.Sheet(url=sample_url1, saved=".", desc="Get Sample Sheet")
>>> sheet.snapshot()
📝 Get Sample Sheet
🚀 snapshot.xlsx
🚚 20210407T172202_snapshot.xlsx

URLを指定してSheetオブジェクトを作成

>>> confd = "./config_toml/"
>>> url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
>>> desc = "URLを指定してSheetオブジェクトを作成"
>>> sheet = ss.core.Sheet(confd=confd, url=url, saved="./snapd/", desc=desc)
>>> # sheet.download()
>>> # sheet.backup()
>>> sheet.snapshot()

Keyを指定してSheetオブジェクトを作成

>>> confd = "./config_toml/"
>>> key = "1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM"
>>> desc = "Keyを指定してSheetオブジェクトを作成"
>>> sheet = ss.core.Sheet(confd=confd, url=key, saved="./snapd/", desc=desc)
>>> sheet.snapshot()

Configurations

config_toml/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_toml/sheets.toml

[sheets]

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

[sheets.toml_sample2]
name = "toml_sample2"
desc = "SSD/HDD Storage Comparison"
url = "https://docs.google.com/spreadsheets/d/16Sc_UgShNuxMfRnBiFsjmfThE1VfVhJf3jgmxNvFeEI/edit#gid=2015536778"
gid = "None"
format = "xlsx"
datefmt = "%Y%m%d"
skip = true