Versions in this module Expand all Collapse all v1 v1.1.0 Jun 10, 2021 v1.0.0 Jun 9, 2021 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 + var ErrorNotFound = errors.New("not found") + func PasswordHash(s string) string + 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 struct + func (c Cell) AddHyperlink(url string) + func (c Cell) Clear() + func (c Cell) Column() (string, error) + func (c Cell) GetCachedFormulaResult() string + func (c Cell) GetFormattedValue() string + func (c Cell) GetFormula() string + func (c Cell) GetRawValue() (string, error) + 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) HasFormula() bool + func (c Cell) IsBool() bool + func (c Cell) IsEmpty() bool + func (c Cell) IsNumber() bool + func (c Cell) Reference() string + func (c Cell) SetBool(v bool) + func (c Cell) SetCachedFormulaResult(s string) + func (c Cell) SetDate(d time.Time) + func (c Cell) SetDateWithStyle(d time.Time) + func (c Cell) SetFormulaArray(s string) + func (c Cell) SetFormulaRaw(s string) + func (c Cell) SetFormulaShared(formula string, rows, cols uint32) error + func (c Cell) SetHyperlink(hl common.Hyperlink) + func (c Cell) SetInlineString(s string) + func (c Cell) SetNumber(v float64) + func (c Cell) SetNumberWithStyle(v float64, f StandardFormat) + func (c Cell) SetRichTextString() RichText + func (c Cell) SetString(s string) int + func (c Cell) SetStringByID(id int) + func (c Cell) SetStyle(cs CellStyle) + func (c Cell) SetStyleIndex(idx uint32) + func (c Cell) SetTime(d time.Time) + func (c Cell) X() *sml.CT_Cell + 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 struct + func (cs CellStyle) ClearBorder() + func (cs CellStyle) ClearFill() + func (cs CellStyle) ClearFont() + func (cs CellStyle) ClearNumberFormat() + func (cs CellStyle) HasNumberFormat() bool + func (cs CellStyle) Index() uint32 + func (cs CellStyle) NumberFormat() uint32 + func (cs CellStyle) SetBorder(b Border) + func (cs CellStyle) SetFill(f Fill) + func (cs CellStyle) SetFont(f Font) + func (cs CellStyle) SetHorizontalAlignment(a sml.ST_HorizontalAlignment) + func (cs CellStyle) SetNumberFormat(s string) + func (cs CellStyle) SetNumberFormatStandard(s StandardFormat) + func (cs CellStyle) SetRotation(deg uint8) + 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 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) error + func (c Comments) Comments() []Comment + func (c Comments) X() *sml.Comments + type Comparer struct + Order SortOrder + func (c Comparer) LessCells(lhs, rhs Cell) bool + func (c Comparer) LessRows(column string, lhs, rhs Row) bool + 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 struct + func (f Fill) Index() uint32 + func (f Fill) SetPatternFill() PatternFill + type Fills struct + func NewFills() Fills + func (f Fills) AddFill() Fill + 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 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 CreateDefaultNumberFormat(id StandardFormat) NumberFormat + func (n NumberFormat) GetFormat() string + func (n NumberFormat) ID() uint32 + func (n NumberFormat) SetFormat(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 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_PatternFill + 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 struct + func (r Row) AddCell() Cell + func (r Row) AddNamedCell(col string) Cell + func (r Row) Cell(col string) Cell + func (r Row) Cells() []Cell + func (r Row) IsHidden() bool + func (r Row) RowNumber() uint32 + func (r Row) SetHeight(d measurement.Distance) + func (r Row) SetHeightAuto() + func (r Row) SetHidden(hidden bool) + func (r Row) X() *sml.CT_Row + 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) AddView() SheetView + func (s *Sheet) ClearCachedFormulaResults() + func (s *Sheet) ClearProtection() + func (s *Sheet) ClearSheetViews() + func (s *Sheet) FormulaContext() formula.Context + func (s *Sheet) InitialView() SheetView + func (s *Sheet) Protection() SheetProtection + func (s *Sheet) RecalculateFormulas() + func (s *Sheet) SetFrozen(firstRow, firstCol bool) + func (s *Sheet) SheetViews() []SheetView + func (s *Sheet) Sort(column string, firstRow uint32, order SortOrder) + 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) AddRow() 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) ExtentsIndex() (string, uint32, string, uint32) + func (s Sheet) InsertRow(rowNum int) Row + func (s Sheet) IsValid() bool + func (s Sheet) MergedCells() []MergedCell + func (s Sheet) Name() string + func (s Sheet) RangeReference(n string) string + func (s Sheet) RemoveMergedCell(mc MergedCell) + func (s Sheet) Row(rowNum uint32) Row + func (s Sheet) Rows() []Row + func (s Sheet) SetAutoFilter(rangeRef string) + func (s Sheet) SetBorder(cellRange string, border Border) error + func (s Sheet) SetDrawing(d Drawing) + func (s Sheet) SetName(name string) + func (s Sheet) Validate() error + func (s Sheet) ValidateWithPath(path string) error + func (s Sheet) X() *sml.Worksheet + 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 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 SortOrder byte + const SortOrderAscending + const SortOrderDescending + func (i SortOrder) String() string + 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 + const StandardFormatWholeNumber + func (i StandardFormat) String() string + type StyleSheet struct + func NewStyleSheet(wb *Workbook) StyleSheet + func (s StyleSheet) AddBorder() Border + func (s StyleSheet) AddCellStyle() CellStyle + func (s StyleSheet) AddDifferentialStyle() DifferentialStyle + func (s StyleSheet) AddFont() Font + func (s StyleSheet) AddNumberFormat() NumberFormat + func (s StyleSheet) CellStyles() []CellStyle + func (s StyleSheet) Fills() Fills + func (s StyleSheet) Fonts() []Font + func (s StyleSheet) GetCellStyle(id uint32) CellStyle + func (s StyleSheet) GetNumberFormat(id uint32) NumberFormat + func (s StyleSheet) GetOrCreateStandardNumberFormat(f StandardFormat) CellStyle + func (s StyleSheet) RemoveFont(f Font) error + func (s StyleSheet) X() *sml.StyleSheet + type Table struct + func (t Table) Name() string + func (t Table) Reference() string + func (t Table) X() *sml.Table + 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 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) AddDefinedName(name, ref string) DefinedName + func (wb *Workbook) AddDrawing() Drawing + func (wb *Workbook) AddImage(i common.Image) (common.ImageRef, error) + func (wb *Workbook) AddSheet() Sheet + func (wb *Workbook) ClearCachedFormulaResults() + func (wb *Workbook) ClearProtection() + func (wb *Workbook) Close() error + func (wb *Workbook) DefinedNames() []DefinedName + func (wb *Workbook) Epoch() time.Time + func (wb *Workbook) GetSheet(name string) (Sheet, error) + func (wb *Workbook) Protection() WorkbookProtection + func (wb *Workbook) RecalculateFormulas() + func (wb *Workbook) RemoveCalcChain() + func (wb *Workbook) RemoveDefinedName(dn DefinedName) error + func (wb *Workbook) Save(w io.Writer) error + func (wb *Workbook) SaveToFile(path string) error + func (wb *Workbook) SetActiveSheet(s Sheet) + func (wb *Workbook) SetActiveSheetIndex(idx uint32) + func (wb *Workbook) Sheets() []Sheet + func (wb *Workbook) Tables() []Table + func (wb *Workbook) Uses1904Dates() bool + func (wb *Workbook) Validate() error + func (wb *Workbook) X() *sml.Workbook + func (wb Workbook) SheetCount() int + 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
Go to main page