gsheets

Documentation

Index

• func AddLatestRow(svc *sheets.Service, sheetID, worksheet string) error
• func AddRow(svc *sheets.Service, sheetID, worksheet string, row []interface{}) error
• func DeleteLastRows(svc *sheets.Service, sheetID string, worksheetID int64, count int64) error
• func GetHeadersFromSheet(svc *sheets.Service, sheetID, worksheet string) ([]string, error)
• func GetWorksheetID(svc *sheets.Service, sheetID, worksheet string) (int64, error)
• func GetWorksheetTotalRows(svc *sheets.Service, sheetID, worksheet string) (int64, error)
• func MakeWorksheet(svc *sheets.Service, sheetID, worksheet string) error
• func NewService(keyPath string) (*sheets.Service, error)
• func SetHeaders(svc *sheets.Service, sheetID, worksheet string, headers []string) error
• type SheetRow
• type SheetRows
  • func MapFromSheet(svc *sheets.Service, sheetID, worksheet string) (*SheetRows, error)

Functions

func AddLatestRow

func AddLatestRow(svc *sheets.Service, sheetID, worksheet string) error

AddLatestRow will add a row just after the header displaying the latest results

func AddRow

func AddRow(svc *sheets.Service, sheetID, worksheet string, row []interface{}) error

AddRow will add a slice of strings as a new row

func DeleteLastRows

func DeleteLastRows(svc *sheets.Service, sheetID string, worksheetID int64, count int64) error

DeleteLastRows will delete the oldest X rows based on count value

func GetHeadersFromSheet

func GetHeadersFromSheet(svc *sheets.Service, sheetID, worksheet string) ([]string, error)

GetHeadersFromSheet will return the current headers present in a sheet

func GetWorksheetID

func GetWorksheetID(svc *sheets.Service, sheetID, worksheet string) (int64, error)

GetWorksheetID will get the gid= value from a worksheet

func GetWorksheetTotalRows

func GetWorksheetTotalRows(svc *sheets.Service, sheetID, worksheet string) (int64, error)

GetWorksheetTotalRows will return the total rows worksheet

func MakeWorksheet

func MakeWorksheet(svc *sheets.Service, sheetID, worksheet string) error

MakeWorksheet will check if a worksheet exists or make one

func NewService

func NewService(keyPath string) (*sheets.Service, error)

NewService is used to generate a Google Spreadsheets API service

func SetHeaders

func SetHeaders(svc *sheets.Service, sheetID, worksheet string, headers []string) error

SetHeaders will set the supplied headers as the first row in sheet

Types

type SheetRow

type SheetRow map[string]interface{}

SheetRow is for unpacking single rows from Gsheets based on a slice of maps

type SheetRows

type SheetRows []map[string]interface{}

SheetRows is for unpacking multiple rows from Gsheets based on a slice of maps

func MapFromSheet

func MapFromSheet(svc *sheets.Service, sheetID, worksheet string) (*SheetRows, error)

MapFromSheet is used to pull all records from a Gsheet and return SheetRows