sv_sheet

Documentation

Index

• Variables
• type RenderOpt
  • func DateTimeRenderOption(opt string) RenderOpt
  • func ValueRenderOption(opt string) RenderOpt
• type RenderOpts
  • func (z RenderOpts) Apply(opts []RenderOpt) RenderOpts
• type Sheet
  • func New(ctx goog_context.Context) Sheet

Variables

var (
	ValueRenderOptionFormatted   = "FORMATTED_VALUE"
	ValueRenderOptionUnformatted = "UNFORMATTED_VALUE"
	ValueRenderOptionFormula     = "FORMULA"
	ValueRenderOptionsFull       = []string{
		ValueRenderOptionFormatted,
		ValueRenderOptionUnformatted,
		ValueRenderOptionFormula,
	}

	ValueRenderOptionAliasFormatted   = "formatted"
	ValueRenderOptionAliasUnformatted = "unformatted"
	ValueRenderOptionAliasFormula     = "formula"
	ValueRenderOptionAliases          = []string{
		ValueRenderOptionAliasFormatted,
		ValueRenderOptionAliasFormatted,
		ValueRenderOptionAliasFormula,
	}

	DateTimeRenderOptionSerialNumber = "SERIAL_NUMBER"
	DateTimeRenderOptionFormatted    = "FORMATTED_STRING"
	DateTimeRenderOptionsFull        = []string{
		DateTimeRenderOptionSerialNumber,
		DateTimeRenderOptionFormatted,
	}

	DateTimeRenderOptionAliasSerialNumber = "serial"
	DateTimeRenderOptionAliasFormatted    = "formatted"
	DateTimeRenderOptionAliases           = []string{
		DateTimeRenderOptionAliasSerialNumber,
		DateTimeRenderOptionAliasFormatted,
	}
)

Types

type RenderOpt

type RenderOpt func(o RenderOpts) RenderOpts

func DateTimeRenderOption

func DateTimeRenderOption(opt string) RenderOpt

func ValueRenderOption

func ValueRenderOption(opt string) RenderOpt

type RenderOpts

type RenderOpts struct {
	ValueRenderOption    string `url:"valueRenderOption,omitempty"`
	DateTimeRenderOption string `url:"dateTimeRenderOption,omitempty"`
}

func (RenderOpts) Apply

func (z RenderOpts) Apply(opts []RenderOpt) RenderOpts

type Sheet

type Sheet interface {
	Clear(spreadsheetId, sheetRange string) (clearedRange string, err error)
	Export(spreadsheetId, sheetRange string, opts ...RenderOpt) (value to_cell.ValueRange, err error)
	Import(spreadsheetId, sheetRange string, values [][]interface{}, rawInput bool) (updated bo_sheet.ValueUpdate, err error)
	Append(spreadsheetId, sheetRange string, values [][]interface{}, rawInput bool) (appended bo_sheet.ValueAppend, err error)
}

func New

func New(ctx goog_context.Context) Sheet