X-Git-Url: https://git.cworth.org/git?a=blobdiff_plain;f=turbot%2Fsheets.py;h=9f8b7c3e0d38eabb0fd08332b684ea39789fea66;hb=3f380c6d5227b99d703d5c8ed3c753e4d179415a;hp=806ba193bd2e60cc32de7577a7100c3f37ef5b7e;hpb=624246022aa384ddeff56bd3bdbbe8fe86b5799f;p=turbot diff --git a/turbot/sheets.py b/turbot/sheets.py index 806ba19..9f8b7c3 100644 --- a/turbot/sheets.py +++ b/turbot/sheets.py @@ -1,5 +1,6 @@ PUZZLE_TEMPLATE_ID = "1drSoyrE4gM3JaGweDkOybwXWdKPIDTfUmB1gQCYS3Uw" -PUZZLE_TEMPLATE_SHEETS = ["Text", "Grid"] +PUZZLE_TEMPLATE_SHEETS = ["Text", "Square grid", "Hex Grid", + "Formula reference: indexing"] def sheets_create(turb, name): """Create a new sheet with the given name. @@ -61,7 +62,10 @@ def sheets_create_for_puzzle(turb, puzzle): insertDataOption='INSERT_ROWS', body={ 'range': 'A1:A2', - 'values': [['=HYPERLINK("'+url_link+'","'+url_text+'")'], ['=HYPERLINK("'+channel_url_link+'","'+channel_url_text+'")']] + 'values': [ + ['=HYPERLINK("'+url_link+'","'+url_text+'")'], + ['=HYPERLINK("'+channel_url_link+'","'+channel_url_text+'")'] + ] }).execute() # Copy some sheets from the Template spreadsheet @@ -100,8 +104,8 @@ def renameSheet(turb, url, newName): ).execute() def extractIdFromSheetUrl(url): - # Google sheet ids are between the /d/ and /edit in the url, like https://docs.google.com/spreadsheets/d/1dxHBzjenjhCAJQ8lM0skJO2mxlup8aWZm0-LaXeVPrg/edit#gid=0 + # Google sheet ids are between the /d/ and /edit in the url, like + # https://docs.google.com/spreadsheets/d/1dxHBzjen...-LaXeVPrg/edit#gid=0 startIndex = url.find('/d/') + 3 endIndex = url.find('/edit') return url[startIndex : endIndex] - \ No newline at end of file