sheets

type Cell ¶

type Cell struct {
	Text      string
	Hyperlink string
}

func (c *Cell) HyperlinkFormula() string

type Row ¶

type Row struct {
	Cells    []*Cell
	Color    color.Color
	BoldText bool
}

func TotalRow(values ...string) *Row

func (r *Row) ToCells() []string

type Spreadsheet ¶

type Spreadsheet struct {
	// contains filtered or unexported fields
}

Spreadsheet represents a Google Spreadsheet, which can contain multiple sheets, each with structured information contained in cells. A Spreadsheet has a unique spreadsheetID value, which can be found in a Google Sheets URL. See https://developers.google.com/sheets/api/guides/concepts for more information.

func Create(ctx context.Context, credentialsFile, tokenFile, title string, data map[string][]*Row) (*Spreadsheet, error)

func Open(ctx context.Context, credentialsFile, tokenFile, id string) (*Spreadsheet, error)

func (s *Spreadsheet) Append(ctx context.Context, data map[string][]*Row) error

func (s *Spreadsheet) GetValues(ctx context.Context, readRange string) ([][]interface{}, error)

func (s *Spreadsheet) ResizeColumns(ctx context.Context) error