Documentation
¶
Index ¶
- Constants
- func AddColumn(sheetID int64, spreadsheetID string, srv *sheets.Service)
- func ArchiveResultsForMonth(contactGroupName, period, spreadsheetID, nodePingToken string, countLimit int)
- func ConvertColumnIndexToLetter(index int64) (string, error)
- func EnsureCheckRowExists(nodePingCheck, year string, sheetsData SheetsData) (int, error)
- func EnsureMonthColumnExists(month, year string, sheetsData SheetsData) (int, error)
- func EnsureSheetExists(sheetName string, sheetsData SheetsData) (int64, error)
- func GetAuthConfig() *jwt.Config
- func GetMonthPosition(monthLabel string) (int, error)
- func GetRequiredEnvVar(envName string) string
- func GetSheetIDFromTitle(title string, sheetsData SheetsData) (bool, int64, error)
- func InsertColumn(index, sheetID int64, spreadsheetID string, srv *sheets.Service) error
- func InsertRow(index, sheetID int64, spreadsheetID string, srv *sheets.Service) error
- func InsertRowOrColumn(insertRowNotColumn bool, index, sheetID int64, spreadsheetID string, ...) error
- func WriteToCellWithColumnIndex(rowIndex, columnIndex int64, newValue, sheetName, spreadsheetID string, ...) error
- func WriteToCellWithColumnLetter(rowIndex int64, columnLetter, newValue, sheetName, spreadsheetID string, ...) error
- type SheetsData
Constants ¶
View Source
const MonthHeaderRow = 2
Variables ¶
This section is empty.
Functions ¶
func AddColumn ¶
AddColumn inserts an additional column at the right of the existing columns of the Sheet
func ArchiveResultsForMonth ¶
func EnsureCheckRowExists ¶
func EnsureCheckRowExists(nodePingCheck, year string, sheetsData SheetsData) (int, error)
EnsureCheckRowExists looks for a match for the check name in the Sheet's A column (starting at row 3) If it finds a match or a blank cell, it returns that row number. Otherwise, it looks down the column until it finds an existing check name that comes after it in terms of alphabetical order. Once it finds such an existing check name, it inserts a row above the existing row and then inserts the new check name into the first cell of the inserted row.
func EnsureMonthColumnExists ¶
func EnsureMonthColumnExists(month, year string, sheetsData SheetsData) (int, error)
func EnsureSheetExists ¶
func EnsureSheetExists(sheetName string, sheetsData SheetsData) (int64, error)
func GetAuthConfig ¶
func GetMonthPosition ¶
func GetRequiredEnvVar ¶
func GetSheetIDFromTitle ¶
func GetSheetIDFromTitle(title string, sheetsData SheetsData) (bool, int64, error)
func InsertColumn ¶
func InsertRowOrColumn ¶
Types ¶
type SheetsData ¶
Source Files
Click to show internal directories.
Click to hide internal directories.