spreadsheet

package

Go to main page

Versions in this module

v0

v0.7.1

May 25, 2018

v0.7.0

Mar 31, 2018

v0.6.0

Feb 6, 2018

Changes in this version

+ var ErrorNotFound = errors.New("not found")

type Cell

+ func (c Cell) Column() (string, error)

+ func (c Cell) SetFormulaShared(formula string, rows, cols uint32) error

type Workbook

+ func (wb *Workbook) Close() error

v0.4.0

Sep 29, 2017

Changes in this version

+ func ParseRangeReference(s string) (from, to string, err error)

+ func PasswordHash(s string) string

type Cell

+ func (c Cell) SetCachedFormulaResult(s string)

+ func (c Cell) SetFormulaArray(s string)

+ type Comparer struct

+ Order SortOrder

+ func (c Comparer) LessCells(lhs, rhs Cell) bool

+ func (c Comparer) LessRows(column string, lhs, rhs Row) bool

type Sheet

+ func (s *Sheet) ClearProtection()

+ func (s *Sheet) Protection() SheetProtection

+ func (s *Sheet) Sort(column string, firstRow uint32, order SortOrder)

+ func (s Sheet) IsValid() bool

+ type SheetProtection struct

+ func (p SheetProtection) IsObjectLocked() bool

+ func (p SheetProtection) IsSheetLocked() bool

+ func (p SheetProtection) LockObject(b bool)

+ func (p SheetProtection) LockSheet(b bool)

+ func (p SheetProtection) PasswordHash() string

+ func (p SheetProtection) SetPassword(pw string)

+ func (p SheetProtection) SetPasswordHash(pwHash string)

+ func (p SheetProtection) X() *sml.CT_SheetProtection

+ type SortOrder byte

+ const SortOrderAscending

+ const SortOrderDescending

+ func (i SortOrder) String() string

type StandardFormat

+ const StandardFormatWholeNumber

+ func (i StandardFormat) String() string

type Workbook

+ func (wb *Workbook) ClearProtection()

+ func (wb *Workbook) GetSheet(name string) Sheet

+ func (wb *Workbook) Protection() WorkbookProtection

+ type WorkbookProtection struct

+ func (p WorkbookProtection) IsStructureLocked() bool

+ func (p WorkbookProtection) IsWindowLocked() bool

+ func (p WorkbookProtection) LockStructure(b bool)

+ func (p WorkbookProtection) LockWindow(b bool)

+ func (p WorkbookProtection) PasswordHash() string

+ func (p WorkbookProtection) SetPassword(pw string)

+ func (p WorkbookProtection) SetPasswordHash(pwHash string)

+ func (p WorkbookProtection) X() *sml.CT_WorkbookProtection

v0.3.0

Sep 19, 2017

Changes in this version

type Cell

+ func (c Cell) GetCachedFormulaResult() string

+ func (c Cell) GetFormattedValue() string

+ func (c Cell) GetFormula() string

+ func (c Cell) GetRawValue() (string, error)

+ func (c Cell) HasFormula() bool

+ func (c Cell) IsBool() bool

+ func (c Cell) IsEmpty() bool

+ func (c Cell) IsNumber() bool

type NumberFormat

+ func CreateDefaultNumberFormat(id StandardFormat) NumberFormat

+ func (n NumberFormat) GetFormat() string

+ func (n NumberFormat) SetFormat(f string)

type Sheet

+ func (s *Sheet) FormulaContext() formula.Context

+ func (s *Sheet) RecalculateFormulas()

+ func (s Sheet) ExtentsIndex() (string, uint32, string, uint32)

type StyleSheet

+ func (s StyleSheet) GetCellStyle(id uint32) CellStyle

+ func (s StyleSheet) GetNumberFormat(id uint32) NumberFormat

+ type Table struct

+ func (t Table) Name() string

+ func (t Table) Reference() string

+ func (t Table) X() *sml.Table

type Workbook

+ func (w *Workbook) Tables() []Table

+ func (wb *Workbook) RecalculateFormulas()

v0.2.0

Sep 12, 2017

Changes in this version

+ const DVCompareOpBetween

+ const DVCompareOpEqual

+ const DVCompareOpGreater

+ const DVCompareOpGreaterEqual

+ const DVCompareOpLess

+ const DVCompareOpLessEqual

+ const DVCompareOpNotBetween

+ const DVCompareOpNotEqual

+ const DVCompareTypeDate

+ const DVCompareTypeDecimal

+ const DVCompareTypeTime

+ const DVCompareTypeWholeNumber

+ const DVOpGreater

+ const DVompareTypeTextLength

+ func ColumnToIndex(col string) uint32

+ func IndexToColumn(col uint32) string

+ func ParseCellReference(s string) (col string, row uint32, err error)

+ type AbsoluteAnchor struct

+ func (a AbsoluteAnchor) BottomRight() CellMarker

+ func (a AbsoluteAnchor) MoveTo(x, y int32)

+ func (a AbsoluteAnchor) SetColOffset(m measurement.Distance)

+ func (a AbsoluteAnchor) SetHeight(h measurement.Distance)

+ func (a AbsoluteAnchor) SetHeightCells(int32)

+ func (a AbsoluteAnchor) SetRowOffset(m measurement.Distance)

+ func (a AbsoluteAnchor) SetWidth(w measurement.Distance)

+ func (a AbsoluteAnchor) SetWidthCells(int32)

+ func (a AbsoluteAnchor) TopLeft() CellMarker

+ func (a AbsoluteAnchor) Type() AnchorType

+ type Anchor interface

+ BottomRight func() CellMarker

+ MoveTo func(col, row int32)

+ SetColOffset func(m measurement.Distance)

+ SetHeight func(w measurement.Distance)

+ SetHeightCells func(h int32)

+ SetRowOffset func(m measurement.Distance)

+ SetWidth func(w measurement.Distance)

+ SetWidthCells func(w int32)

+ TopLeft func() CellMarker

+ Type func() AnchorType

+ type AnchorType byte

+ const AnchorTypeAbsolute

+ const AnchorTypeOneCell

+ const AnchorTypeTwoCell

+ type Border struct

+ func (b Border) Index() uint32

+ func (b Border) InitializeDefaults()

+ func (b Border) SetBottom(style sml.ST_BorderStyle, c color.Color)

+ func (b Border) SetDiagonal(style sml.ST_BorderStyle, c color.Color, up, down bool)

+ func (b Border) SetLeft(style sml.ST_BorderStyle, c color.Color)

+ func (b Border) SetRight(style sml.ST_BorderStyle, c color.Color)

+ func (b Border) SetTop(style sml.ST_BorderStyle, c color.Color)

+ func (b Border) X() *sml.CT_Border

type Cell

+ func (c Cell) AddHyperlink(url string)

+ func (c Cell) Clear()

+ func (c Cell) GetString() string

+ func (c Cell) GetValueAsBool() (bool, error)

+ func (c Cell) GetValueAsNumber() (float64, error)

+ func (c Cell) GetValueAsTime() (time.Time, error)

+ func (c Cell) Reference() string

+ func (c Cell) SetDate(d time.Time)

+ func (c Cell) SetDateWithStyle(d time.Time)

+ func (c Cell) SetHyperlink(hl common.Hyperlink)

+ func (c Cell) SetNumberWithStyle(v float64, f StandardFormat)

+ func (c Cell) SetRichTextString() RichText

+ func (c Cell) SetStyleIndex(idx uint32)

+ func (c Cell) SetTime(d time.Time)

+ type CellMarker struct

+ func (c CellMarker) Col() int32

+ func (c CellMarker) ColOffset() measurement.Distance

+ func (c CellMarker) Row() int32

+ func (c CellMarker) RowOffset() measurement.Distance

+ func (c CellMarker) SetCol(col int32)

+ func (c CellMarker) SetColOffset(m measurement.Distance)

+ func (c CellMarker) SetRow(row int32)

+ func (c CellMarker) SetRowOffset(m measurement.Distance)

+ func (c CellMarker) X() *sd.CT_Marker

type CellStyle

+ func (cs CellStyle) ClearBorder()

+ func (cs CellStyle) ClearFill()

+ func (cs CellStyle) ClearNumberFormat()

+ func (cs CellStyle) HasNumberFormat() bool

+ func (cs CellStyle) NumberFormat() uint32

+ func (cs CellStyle) SetBorder(b Border)

+ func (cs CellStyle) SetNumberFormat(s string)

+ func (cs CellStyle) SetNumberFormatStandard(s StandardFormat)

+ type ColorScale struct

+ func (c ColorScale) AddFormatValue(t sml.ST_CfvoType, val string)

+ func (c ColorScale) AddGradientStop(color color.Color)

+ func (c ColorScale) X() *sml.CT_ColorScale

+ type Column struct

+ func (c Column) SetHidden(b bool)

+ func (c Column) SetStyle(cs CellStyle)

+ func (c Column) SetWidth(w measurement.Distance)

+ func (c Column) X() *sml.CT_Col

+ type Comment struct

+ func (c Comment) Author() string

+ func (c Comment) CellReference() string

+ func (c Comment) SetAuthor(author string)

+ func (c Comment) SetCellReference(cellRef string)

+ func (c Comment) X() *sml.CT_Comment

+ type Comments struct

+ func MakeComments(w *Workbook, x *sml.Comments) Comments

+ func (c Comments) AddComment(cellRef string, author string) RichText

+ func (c Comments) AddCommentWithStyle(cellRef string, author string, comment string)

+ func (c Comments) Comments() []Comment

+ func (c Comments) X() *sml.Comments

+ type ConditionalFormatting struct

+ func (c ConditionalFormatting) AddRule() ConditionalFormattingRule

+ func (c ConditionalFormatting) X() *sml.CT_ConditionalFormatting

+ type ConditionalFormattingRule struct

+ func (c ConditionalFormattingRule) InitializeDefaults()

+ func (c ConditionalFormattingRule) Operator() sml.ST_ConditionalFormattingOperator

+ func (c ConditionalFormattingRule) Priority() int32

+ func (c ConditionalFormattingRule) SetColorScale() ColorScale

+ func (c ConditionalFormattingRule) SetConditionValue(v string)

+ func (c ConditionalFormattingRule) SetDataBar() DataBarScale

+ func (c ConditionalFormattingRule) SetIcons() IconScale

+ func (c ConditionalFormattingRule) SetOperator(t sml.ST_ConditionalFormattingOperator)

+ func (c ConditionalFormattingRule) SetPriority(p int32)

+ func (c ConditionalFormattingRule) SetStyle(d DifferentialStyle)

+ func (c ConditionalFormattingRule) SetType(t sml.ST_CfType)

+ func (c ConditionalFormattingRule) Type() sml.ST_CfType

+ func (c ConditionalFormattingRule) X() *sml.CT_CfRule

+ type DVCompareOp byte

+ type DVCompareType byte

+ type DataBarScale struct

+ func (d DataBarScale) AddFormatValue(t sml.ST_CfvoType, val string)

+ func (d DataBarScale) SetColor(c color.Color)

+ func (d DataBarScale) SetMaxLength(l uint32)

+ func (d DataBarScale) SetMinLength(l uint32)

+ func (d DataBarScale) SetShowValue(b bool)

+ func (d DataBarScale) X() *sml.CT_DataBar

+ type DataValidation struct

+ func (d DataValidation) SetAllowBlank(b bool)

+ func (d DataValidation) SetComparison(t DVCompareType, op DVCompareOp) DataValidationCompare

+ func (d DataValidation) SetList() DataValidationList

+ func (d DataValidation) SetRange(cellRange string)

+ func (d DataValidation) X() *sml.CT_DataValidation

+ type DataValidationCompare struct

+ func (d DataValidationCompare) SetValue(v string)

+ func (d DataValidationCompare) SetValue2(v string)

+ type DataValidationList struct

+ func (d DataValidationList) SetRange(cellRange string)

+ func (d DataValidationList) SetValues(values []string)

+ type DefinedName struct

+ func (d DefinedName) Content() string

+ func (d DefinedName) Name() string

+ func (d DefinedName) SetContent(s string)

+ func (d DefinedName) SetHidden(b bool)

+ func (d DefinedName) SetLocalSheetID(id uint32)

+ func (d DefinedName) X() *sml.CT_DefinedName

+ type DifferentialStyle struct

+ func (d DifferentialStyle) Fill() Fill

+ func (d DifferentialStyle) Index() uint32

+ func (d DifferentialStyle) X() *sml.CT_Dxf

+ type Drawing struct

+ func (d Drawing) AddChart(at AnchorType) (chart.Chart, Anchor)

+ func (d Drawing) AddImage(img common.ImageRef, at AnchorType) Anchor

+ func (d Drawing) X() *sd.WsDr

type Fill

+ func (f Fill) SetPatternFill() PatternFill

type Fills

+ func (f Fills) AddFill() Fill

+ type IconScale struct

+ func (c IconScale) AddFormatValue(t sml.ST_CfvoType, val string)

+ func (c IconScale) SetIcons(t sml.ST_IconSetType)

+ func (c IconScale) X() *sml.CT_IconSet

+ type MergedCell struct

+ func (s MergedCell) Cell() Cell

+ func (s MergedCell) Reference() string

+ func (s MergedCell) SetReference(ref string)

+ func (s MergedCell) X() *sml.CT_MergeCell

+ type NumberFormat struct

+ func (n NumberFormat) ID() uint32

+ func (n NumberFormat) SetCode(f string)

+ func (n NumberFormat) X() *sml.CT_NumFmt

+ type OneCellAnchor struct

+ func (o OneCellAnchor) BottomRight() CellMarker

+ func (o OneCellAnchor) MoveTo(col, row int32)

+ func (o OneCellAnchor) SetColOffset(m measurement.Distance)

+ func (o OneCellAnchor) SetHeight(h measurement.Distance)

+ func (o OneCellAnchor) SetHeightCells(int32)

+ func (o OneCellAnchor) SetRowOffset(m measurement.Distance)

+ func (o OneCellAnchor) SetWidth(w measurement.Distance)

+ func (o OneCellAnchor) SetWidthCells(int32)

+ func (o OneCellAnchor) TopLeft() CellMarker

+ func (o OneCellAnchor) Type() AnchorType

+ type RichText struct

+ func (r RichText) AddRun() RichTextRun

+ func (r RichText) X() *sml.CT_Rst

+ type RichTextRun struct

+ func (r RichTextRun) SetBold(b bool)

+ func (r RichTextRun) SetColor(c color.Color)

+ func (r RichTextRun) SetFont(s string)

+ func (r RichTextRun) SetItalic(b bool)

+ func (r RichTextRun) SetSize(m measurement.Distance)

+ func (r RichTextRun) SetText(s string)

+ func (r RichTextRun) SetUnderline(u sml.ST_UnderlineValues)

+ func (r RichTextRun) X() *sml.CT_RElt

type Row

+ func (r Row) AddNamedCell(col string) Cell

+ func (r Row) Cell(col string) Cell

+ func (r Row) RowNumber() uint32

+ func (r Row) X() *spreadsheetml.CT_Row

type Sheet

+ func (s *Sheet) AddView() SheetView

+ func (s *Sheet) ClearCachedFormulaResults()

+ func (s *Sheet) ClearSheetViews()

+ func (s *Sheet) InitialView() SheetView

+ func (s *Sheet) SetFrozen(firstRow, firstCol bool)

+ func (s *Sheet) SheetViews() []SheetView

+ func (s Sheet) AddConditionalFormatting(cellRanges []string) ConditionalFormatting

+ func (s Sheet) AddDataValidation() DataValidation

+ func (s Sheet) AddHyperlink(url string) common.Hyperlink

+ func (s Sheet) AddMergedCells(fromRef, toRef string) MergedCell

+ func (s Sheet) AddNumberedRow(rowNum uint32) Row

+ func (s Sheet) Cell(cellRef string) Cell

+ func (s Sheet) ClearAutoFilter()

+ func (s Sheet) Column(idx uint32) Column

+ func (s Sheet) Comments() Comments

+ func (s Sheet) Extents() string

+ func (s Sheet) MergedCells() []MergedCell

+ func (s Sheet) RangeReference(n string) string

+ func (s Sheet) RemoveMergedCell(mc MergedCell)

+ func (s Sheet) Row(rowNum uint32) Row

+ func (s Sheet) SetAutoFilter(rangeRef string)

+ func (s Sheet) SetBorder(cellRange string, border Border)

+ func (s Sheet) SetDrawing(d Drawing)

+ func (s Sheet) X() *sml.Worksheet

+ type SheetView struct

+ func (s SheetView) SetShowRuler(b bool)

+ func (s SheetView) SetState(st sml.ST_PaneState)

+ func (s SheetView) SetTopLeft(cellRef string)

+ func (s SheetView) SetXSplit(v float64)

+ func (s SheetView) SetYSplit(v float64)

+ func (s SheetView) SetZoom(pct uint32)

+ func (s SheetView) X() *sml.CT_SheetView

+ type StandardFormat uint32

+ const StandardFormat0

+ const StandardFormat1

+ const StandardFormat10

+ const StandardFormat11

+ const StandardFormat12

+ const StandardFormat13

+ const StandardFormat14

+ const StandardFormat15

+ const StandardFormat16

+ const StandardFormat17

+ const StandardFormat18

+ const StandardFormat19

+ const StandardFormat2

+ const StandardFormat20

+ const StandardFormat21

+ const StandardFormat22

+ const StandardFormat3

+ const StandardFormat37

+ const StandardFormat38

+ const StandardFormat39

+ const StandardFormat4

+ const StandardFormat40

+ const StandardFormat45

+ const StandardFormat46

+ const StandardFormat47

+ const StandardFormat48

+ const StandardFormat49

+ const StandardFormat9

+ const StandardFormatDate

+ const StandardFormatDateTime

+ const StandardFormatGeneral

+ const StandardFormatPercent

+ const StandardFormatTime

type StyleSheet

+ func (s StyleSheet) AddBorder() Border

+ func (s StyleSheet) AddDifferentialStyle() DifferentialStyle

+ func (s StyleSheet) AddNumberFormat() NumberFormat

+ func (s StyleSheet) CellStyles() []CellStyle

+ func (s StyleSheet) GetOrCreateStandardNumberFormat(f StandardFormat) CellStyle

+ type TwoCellAnchor struct

+ func (t TwoCellAnchor) BottomRight() CellMarker

+ func (t TwoCellAnchor) MoveTo(col, row int32)

+ func (t TwoCellAnchor) SetColOffset(m measurement.Distance)

+ func (t TwoCellAnchor) SetHeight(h measurement.Distance)

+ func (t TwoCellAnchor) SetHeightCells(h int32)

+ func (t TwoCellAnchor) SetRowOffset(m measurement.Distance)

+ func (t TwoCellAnchor) SetWidth(w measurement.Distance)

+ func (t TwoCellAnchor) SetWidthCells(w int32)

+ func (t TwoCellAnchor) TopLeft() CellMarker

+ func (t TwoCellAnchor) Type() AnchorType

type Workbook

+ func (wb *Workbook) AddDefinedName(name, ref string) DefinedName

+ func (wb *Workbook) AddDrawing() Drawing

+ func (wb *Workbook) AddImage(i common.Image) (common.ImageRef, error)

+ func (wb *Workbook) ClearCachedFormulaResults()

+ func (wb *Workbook) DefinedNames() []DefinedName

+ func (wb *Workbook) Epoch() time.Time

+ func (wb *Workbook) RemoveDefinedName(dn DefinedName) error

+ func (wb *Workbook) SetActiveSheet(s Sheet)

+ func (wb *Workbook) SetActiveSheetIndex(idx uint32)

+ func (wb *Workbook) Uses1904Dates() bool

v0.1.0

Sep 2, 2017

Changes in this version

+ type Borders struct

+ func NewBorders() Borders

+ func (b Borders) X() *sml.CT_Borders

+ type Cell struct

+ func (c Cell) GetValue() (string, error)

+ func (c Cell) SetBool(v bool)

+ func (c Cell) SetFormulaRaw(s string)

+ func (c Cell) SetInlineString(s string)

+ func (c Cell) SetNumber(v float64)

+ func (c Cell) SetString(s string) int

+ func (c Cell) SetStringByID(id int)

+ func (c Cell) SetStyle(cs CellStyle)

+ func (c Cell) X() *sml.CT_Cell

+ type CellStyle struct

+ func (cs CellStyle) ClearFont()

+ func (cs CellStyle) Index() uint32

+ func (cs CellStyle) SetFill(f Fill)

+ func (cs CellStyle) SetFont(f Font)

+ func (cs CellStyle) SetHorizontalAlignment(a sml.ST_HorizontalAlignment)

+ func (cs CellStyle) SetShrinkToFit(b bool)

+ func (cs CellStyle) SetVerticalAlignment(a sml.ST_VerticalAlignment)

+ func (cs CellStyle) SetWrapped(b bool)

+ func (cs CellStyle) Wrapped() bool

+ type Fill struct

+ func (f Fill) Index() uint32

+ type Fills struct

+ func NewFills() Fills

+ func (f Fills) AddPatternFill() PatternFill

+ func (f Fills) X() *sml.CT_Fills

+ type Font struct

+ func (f Font) Index() uint32

+ func (f Font) SetBold(b bool)

+ func (f Font) SetColor(c color.Color)

+ func (f Font) SetItalic(b bool)

+ func (f Font) SetName(name string)

+ func (f Font) SetSize(size float64)

+ func (f Font) X() *sml.CT_Font

+ type PatternFill struct

+ func NewPatternFill(fills *sml.CT_Fills) PatternFill

+ func (f PatternFill) ClearBgColor()

+ func (f PatternFill) ClearFgColor()

+ func (f PatternFill) SetBgColor(c color.Color)

+ func (f PatternFill) SetFgColor(c color.Color)

+ func (f PatternFill) SetPattern(p sml.ST_PatternType)

+ func (f PatternFill) X() *sml.CT_Fill

+ type Row struct

+ func (r Row) AddCell() Cell

+ func (r Row) Cells() []Cell

+ func (r Row) IsHidden() bool

+ func (r Row) SetHeight(d measurement.Distance)

+ func (r Row) SetHeightAuto()

+ func (r Row) SetHidden(hidden bool)

+ type SharedStrings struct

+ func NewSharedStrings() SharedStrings

+ func (s SharedStrings) AddString(v string) int

+ func (s SharedStrings) GetString(id int) (string, error)

+ func (s SharedStrings) X() *sml.Sst

+ type Sheet struct

+ func (s Sheet) AddRow() Row

+ func (s Sheet) Name() string

+ func (s Sheet) Rows() []Row

+ func (s Sheet) SetName(name string)

+ func (s Sheet) Validate() error

+ func (s Sheet) ValidateWithPath(path string) error

+ type StyleSheet struct

+ func NewStyleSheet() StyleSheet

+ func (s StyleSheet) AddCellStyle() CellStyle

+ func (s StyleSheet) AddFont() Font

+ func (s StyleSheet) Fills() Fills

+ func (s StyleSheet) Fonts() []Font

+ func (s StyleSheet) RemoveFont(f Font) error

+ func (s StyleSheet) X() *sml.StyleSheet

+ type Workbook struct

+ SharedStrings SharedStrings

+ StyleSheet StyleSheet

+ func New() *Workbook

+ func Open(filename string) (*Workbook, error)

+ func Read(r io.ReaderAt, size int64) (*Workbook, error)

+ func (wb *Workbook) AddSheet() Sheet

+ func (wb *Workbook) Save(w io.Writer) error

+ func (wb *Workbook) SaveToFile(path string) error

+ func (wb *Workbook) Sheets() []Sheet

+ func (wb *Workbook) Validate() error

+ func (wb *Workbook) X() *sml.Workbook

+ func (wb Workbook) SheetCount() int

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL