Need help with spreadsheet?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

Iwark
283 Stars 37 Forks MIT License 63 Commits 14 Opened issues

Description

Google Go (golang) library for reading and writing spreadsheet files on Google Docs.

Services available

!
?

Need anything else?

Contributors list

# 280,471
Elixir
Shell
Go
golang
38 commits
# 2,231
Go
Shell
webhook
webhook...
6 commits
# 466,329
Python
HTML
Shell
2 commits
# 198,629
discord...
HTML
JavaScr...
Discord
2 commits
# 53,447
Scala
big-dat...
Shell
JavaScr...
1 commit
# 120,015
golang
Go
Shell
microse...
1 commit
# 624,897
Go
golang
1 commit
# 406,659
Shell
JavaScr...
HTML
1 commit

spreadsheet

Build Status Coverage Status GoReport GoDoc License

Package

spreadsheet
provides fast and easy-to-use access to the Google Sheets API for reading and updating spreadsheets.

Any pull-request is welcome.

Installation

go get gopkg.in/Iwark/spreadsheet.v2

Preparation

This package uses oauth2 client for authentication. You need to get service account key from Google Developer Console. Place the

client_secret.json
to the root of your project.

Usage

First you need service to start using this package.

data, err := ioutil.ReadFile("client_secret.json")
checkError(err)

conf, err := google.JWTConfigFromJSON(data, spreadsheet.Scope) checkError(err)

client := conf.Client(context.TODO()) service := spreadsheet.NewServiceWithClient(client)

Or there is a shortcut which does the same things:

service, err := spreadsheet.NewService()

Fetching a spreadsheet

spreadsheetID := "1mYiA2T4_QTFUkAXk0BE3u7snN2o5FgSRqxmRrn_Dzh4"
spreadsheet, err := service.FetchSpreadsheet(spreadsheetID)

Create a spreadsheet

ss, err := service.CreateSpreadsheet(spreadsheet.Spreadsheet{
    Properties: spreadsheet.Properties{
        Title: "spreadsheet title",
    },
})

Find a sheet

// get a sheet by the index.
sheet, err := spreadsheet.SheetByIndex(0)

// get a sheet by the ID. sheet, err := spreadsheet.SheetByID(0)

// get a sheet by the title. sheet, err := spreadsheet.SheetByTitle("SheetTitle")

Get cells

// get the B1 cell content
sheet.Rows[0][1].Value

// get the A2 cell content sheet.Columns[0][1].Value

Update cell content

row := 1
column := 2
sheet.Update(row, column, "hogehoge")
sheet.Update(3, 2, "fugafuga")

// Make sure call Synchronize to reflect the changes. err := sheet.Synchronize()

Expand a sheet

err := service.ExpandSheet(sheet, 20, 10) // Expand the sheet to 20 rows and 10 columns

Delete Rows / Columns

err := sheet.DeleteRows(0, 3) // Delete first three rows in the sheet

err := sheet.DeleteColumns(1, 4) // Delete columns B:D

More usage can be found at the godoc.

Example

package main

import ( "fmt" "io/ioutil"

"gopkg.in/Iwark/spreadsheet.v2"
"golang.org/x/net/context"
"golang.org/x/oauth2/google"

)

func main() { data, err := ioutil.ReadFile("client_secret.json") checkError(err) conf, err := google.JWTConfigFromJSON(data, spreadsheet.Scope) checkError(err) client := conf.Client(context.TODO())

service := spreadsheet.NewServiceWithClient(client)
spreadsheet, err := service.FetchSpreadsheet("1mYiA2T4_QTFUkAXk0BE3u7snN2o5FgSRqxmRrn_Dzh4")
checkError(err)
sheet, err := spreadsheet.SheetByIndex(0)
checkError(err)
for _, row := range sheet.Rows {
    for _, cell := range row {
        fmt.Println(cell.Value)
    }
}

// Update cell content
sheet.Update(0, 0, "hogehoge")

// Make sure call Synchronize to reflect the changes
err = sheet.Synchronize()
checkError(err)

}

func checkError(err error) { if err != nil { panic(err.Error()) } }

License

Spreadsheet is released under the MIT License.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.