sheets

package module

v0.0.0-...-c3ab7e9 Latest Latest Go to latest Published: Mar 22, 2022 License: MIT Imports: 14 Imported by: 3

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This project provides a wrapper around the Google Sheets API, simplifying the process of creating and adding formatting to a Google Sheet.

This section is empty.

This section is empty.

func AppendToSheet(ctx context.Context, srv *sheets.Service, spreadsheetID string, rowData map[string][]*sheets.RowData) (*sheets.Spreadsheet, error)

func CreateSheet(ctx context.Context, srv *sheets.Service, title string, rowData map[string][]*sheets.RowData) (*sheets.Spreadsheet, error)

func GetSpreadsheetID(url string) (string, error)

Return the Google Sheets spreadsheet ID for the given URL. If the URL is an invalid format, an error will be returned.

func GoogleSheetsService(ctx context.Context, credentialsFile, tokenFile string) (*sheets.Service, error)

func PaleYellow() color.Color

func Write(_ context.Context, outputDir string, data map[string][]*Row, rowData map[string][]*sheets.RowData) error

Write populates the given rowData with the given data.

type Cell struct {
	Text      string
	Hyperlink string
}

func (c *Cell) HyperlinkFormula() string

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

func TotalRow(values ...string) *Row

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