google

Documentation

Index

• func AddNewSheet(srv *sheets.Service, spreadsheetId string, title string) (*sheets.BatchUpdateSpreadsheetResponse, error)
• func AppendRow(srv *sheets.Service, spreadsheetId string, sheetId int64, values []interface{}) (*sheets.BatchUpdateSpreadsheetResponse, error)
• func DebugBatchUpdateSpreadsheetResponse(resp *sheets.BatchUpdateSpreadsheetResponse)
• func GetSpreadSheetURL(spreadsheetId string) string
• func ReadSheetValuesRange(srv *sheets.Service, spreadsheetId, readRange string) (*sheets.ValueRange, error)
• func ValuesToCellData(values []interface{}) (cells []*sheets.CellData)
• func WriteStructHeader(srv *sheets.Service, spreadsheetId string, sheetId int64, structTag string, ...) (*sheets.BatchUpdateSpreadsheetResponse, error)
• func WriteStructValues(srv *sheets.Service, spreadsheetId string, sheetId int64, structTag string, ...) (*sheets.BatchUpdateSpreadsheetResponse, error)
• type SpreadSheetService
  • func NewSpreadSheetService(ctx context.Context, tokenFile string, spreadsheetID string) *SpreadSheetService

Functions

func AddNewSheet

func AddNewSheet(srv *sheets.Service, spreadsheetId string, title string) (*sheets.BatchUpdateSpreadsheetResponse, error)

func AppendRow

func AppendRow(srv *sheets.Service, spreadsheetId string, sheetId int64, values []interface{}) (*sheets.BatchUpdateSpreadsheetResponse, error)

func DebugBatchUpdateSpreadsheetResponse

func DebugBatchUpdateSpreadsheetResponse(resp *sheets.BatchUpdateSpreadsheetResponse)

func GetSpreadSheetURL

func GetSpreadSheetURL(spreadsheetId string) string

func ReadSheetValuesRange

func ReadSheetValuesRange(srv *sheets.Service, spreadsheetId, readRange string) (*sheets.ValueRange, error)

func ValuesToCellData

func ValuesToCellData(values []interface{}) (cells []*sheets.CellData)

func WriteStructHeader

func WriteStructHeader(srv *sheets.Service, spreadsheetId string, sheetId int64, structTag string, st interface{}) (*sheets.BatchUpdateSpreadsheetResponse, error)

func WriteStructValues

func WriteStructValues(srv *sheets.Service, spreadsheetId string, sheetId int64, structTag string, st interface{}) (*sheets.BatchUpdateSpreadsheetResponse, error)

Types

type SpreadSheetService

type SpreadSheetService struct {
	SpreadsheetID string
	TokenFile     string
	// contains filtered or unexported fields
}

func NewSpreadSheetService

func NewSpreadSheetService(ctx context.Context, tokenFile string, spreadsheetID string) *SpreadSheetService