gsheets

A golang wrapper package for golang.org/x/oauth2 and google.golang.org/api/sheets/v4. You can easily manipulate spreadsheets.

!!! Only for personal use !!!

Installation

go get github.com/delve/gsheets

Requirement

This package uses Google OAuth2.0. So before executing tool, you have to prepare credentials.json. See Go Quickstart, or Blog (Japanese) for the details.

Usage

Create Cache

If you want to use the cache, initialize the context. If you are updating sheets, you should not use Cache.

ctx := gsheets.WithCache(ctx)

Create New Client

client, err := gsheets.New(ctx, `{"credentials": "json"}`, `{"token": "json"}`)

client, err := gsheets.NewForCLI(ctx, "credentials.json")

If you are updating sheets, create a client with ClientWritable option.

client, err := gsheets.New(ctx, `{"credentials": "json"}`, `{"token": "json"}`, gsheets.ClientWritable())

Get Sheet Information

func (*Client) GetTitle(ctx context.Context, spreadsheetID string) (string, error)

func (*Client) GetSheetNames(ctx context.Context, spreadsheetID string) ([]string, error)

func (*Client) GetSheet(ctx context.Context, spreadsheetID, sheetName string) (Sheet, error)

Update Sheet Values

func (c *Client) Update(ctx context.Context, spreadsheetID, sheetName string, rowNo int, values []interface{}) error

func (c *Client) BatchUpdate(ctx context.Context, spreadsheetID string, updateValues ...UpdateValue) error

Manipulate Sheet Values

If the index is out of range, Value method returns empty string.

s, err := client.GetSheet(ctx, "spreadsheetID", "sheetName")
if err != nil {
  return err
}

fmt.Println(s.Value(row, clm))

for _, r := range s.Rows() {
  fmt.Println(r.Value(clm))
}