excelize

package module

Go to main page

Versions in this module

v1

v1.6.1

Jan 14, 2020

v1.6.0

Jan 14, 2020

v1.5.1

May 22, 2019

Changes in this version

+ const Area

+ const Area3D

+ const Area3DPercentStacked

+ const Area3DStacked

+ const AreaPercentStacked

+ const AreaStacked

+ const OrientationLandscape

+ const OrientationPortrait

+ const StrictNameSpaceSpreadSheet

+ const StrictSourceRelationship

+ const StrictSourceRelationshipChart

+ const StrictSourceRelationshipComments

+ const StrictSourceRelationshipImage

+ func CellNameToCoordinates(cell string) (int, int, error)

+ func ColumnNameToNumber(name string) (int, error)

+ func ColumnNumberToName(num int) (string, error)

+ func CoordinatesToCellName(col, row int) (string, error)

+ func JoinCellName(col string, row int) (string, error)

+ func SplitCellName(cell string) (string, int, error)

type File

+ CalcChain *xlsxCalcChain

+ Comments map[string]*xlsxComments

+ DecodeVMLDrawing map[string]*decodeVmlDrawing

+ DrawingRels map[string]*xlsxWorkbookRels

+ Drawings map[string]*xlsxWsDr

+ VMLDrawing map[string]*vmlDrawing

+ WorkSheetRels map[string]*xlsxWorkbookRels

+ func (f *File) DuplicateRow(sheet string, row int) error

+ func (f *File) DuplicateRowTo(sheet string, row, row2 int) error

+ func (f *File) GetMergeCells(sheet string) ([]MergeCell, error)

+ func (f *File) GetPageLayout(sheet string, opts ...PageLayoutOptionPtr) error

+ func (f *File) ProtectSheet(sheet string, settings *FormatSheetProtection) error

+ func (f *File) SearchSheet(sheet, value string, reg ...bool) ([]string, error)

+ func (f *File) SetCellFloat(sheet, axis string, value float64, prec, bitSize int) error

+ func (f *File) SetColStyle(sheet, columns string, styleID int) error

+ func (f *File) SetHeaderFooter(sheet string, settings *FormatHeaderFooter) error

+ func (f *File) SetPageLayout(sheet string, opts ...PageLayoutOption) error

+ func (f *File) UnprotectSheet(sheet string) error

+ func (f *File) WriteToBuffer() (*bytes.Buffer, error)

+ type FormatHeaderFooter struct

+ AlignWithMargins bool

+ DifferentFirst bool

+ DifferentOddEven bool

+ EvenFooter string

+ EvenHeader string

+ FirstFooter string

+ FirstHeader string

+ OddFooter string

+ OddHeader string

+ ScaleWithDoc bool

+ type FormatSheetProtection struct

+ AutoFilter bool

+ DeleteColumns bool

+ DeleteRows bool

+ EditObjects bool

+ EditScenarios bool

+ FormatCells bool

+ FormatColumns bool

+ FormatRows bool

+ InsertColumns bool

+ InsertHyperlinks bool

+ InsertRows bool

+ Password string

+ PivotTables bool

+ SelectLockedCells bool

+ SelectUnlockedCells bool

+ Sort bool

+ type MergeCell []string

+ func (m *MergeCell) GetCellValue() string

+ func (m *MergeCell) GetEndAxis() string

+ func (m *MergeCell) GetStartAxis() string

+ type OutlineSummaryBelow bool

+ type PageLayoutOption interface

+ type PageLayoutOptionPtr interface

+ type PageLayoutOrientation string

+ type PageLayoutPaperSize int

+ type TopLeftCell string

v1.4.0

Sep 13, 2018

Changes in this version

+ const DataValidationOperatorBetween

+ const DataValidationOperatorEqual

+ const DataValidationOperatorGreaterThan

+ const DataValidationOperatorGreaterThanOrEqual

+ const DataValidationOperatorLessThan

+ const DataValidationOperatorLessThanOrEqual

+ const DataValidationOperatorNotBetween

+ const DataValidationOperatorNotEqual

+ const DataValidationTypeCustom

+ const DataValidationTypeDate

+ const DataValidationTypeDecimal

+ const DataValidationTypeTextLeng

+ const DataValidationTypeTime

+ const DataValidationTypeWhole

+ const STCellFormulaTypeArray

+ const STCellFormulaTypeDataTable

+ const STCellFormulaTypeNormal

+ const STCellFormulaTypeShared

+ var HSLModel = color.ModelFunc(hslModel)

+ func HSLToRGB(h, s, l float64) (r, g, b uint8)

+ func RGBToHSL(r, g, b uint8) (h, s, l float64)

+ func ThemeColor(baseColor string, tint float64) string

+ type Comment struct

+ Author string

+ AuthorID int

+ Ref string

+ Text string

+ type DataValidation struct

+ AllowBlank bool

+ Error *string

+ ErrorStyle *string

+ ErrorTitle *string

+ Formula1 string

+ Formula2 string

+ Operator string

+ Prompt *string

+ PromptTitle *string

+ ShowDropDown bool

+ ShowErrorMessage bool

+ ShowInputMessage bool

+ Sqref string

+ Type string

+ func NewDataValidation(allowBlank bool) *DataValidation

+ func (dd *DataValidation) SetDropList(keys []string) error

+ func (dd *DataValidation) SetError(style DataValidationErrorStyle, title, msg string)

+ func (dd *DataValidation) SetInput(title, msg string)

+ func (dd *DataValidation) SetRange(f1, f2 int, t DataValidationType, o DataValidationOperator) error

+ func (dd *DataValidation) SetSqref(sqref string)

+ func (dd *DataValidation) SetSqrefDropList(sqref string, isCurrentSheet bool) error

+ type DataValidationErrorStyle int

+ const DataValidationErrorStyleInformation

+ const DataValidationErrorStyleStop

+ const DataValidationErrorStyleWarning

+ type DataValidationOperator int

+ type DataValidationType int

type File

+ Theme *xlsxTheme

+ func (f *File) AddDataValidation(sheet string, dv *DataValidation)

+ func (f *File) AddPictureFromBytes(sheet, cell, format, name, extension string, file []byte) error

+ func (f *File) GetComments() (comments map[string][]Comment)

+ func (f *File) WriteTo(w io.Writer) (int64, error)

+ type HSL struct

+ H float64

+ L float64

+ S float64

+ func (c HSL) RGBA() (uint32, uint32, uint32, uint32)

v1.3.0

May 11, 2018

Changes in this version

+ const Bar3DClustered

+ const Bar3DPercentStacked

+ const Bar3DStacked

+ const BarPercentStacked

+ const Col

+ const Col3D

+ const Col3DClustered

+ const Col3DPercentStacked

+ const Col3DStacked

+ const ColPercentStacked

+ const ColStacked

+ var XMLHeaderByte = []byte(XMLHeader)

+ type ErrSheetNotExist struct

+ SheetName string

+ func (err ErrSheetNotExist) Error() string

type File

+ func (f *File) GetColOutlineLevel(sheet, column string) uint8

+ func (f *File) GetRowOutlineLevel(sheet string, rowIndex int) uint8

+ func (f *File) Rows(sheet string) (*Rows, error)

+ func (f *File) SetCellBool(sheet, axis string, value bool)

+ func (f *File) SetColOutlineLevel(sheet, column string, level uint8)

+ func (f *File) SetRowOutlineLevel(sheet string, rowIndex int, level uint8)

+ func (f *File) SetSheetRow(sheet, axis string, slice interface{})

+ type Rows struct

+ func (rows *Rows) Columns() []string

+ func (rows *Rows) Error() error

+ func (rows *Rows) Next() bool

+ type ZoomScale float64

v1.2.0

Dec 1, 2017

Changes in this version

+ const BarStacked

+ type AutoPageBreaks bool

+ type CodeName string

+ type DefaultGridColor bool

+ type EnableFormatConditionsCalculation bool

type File

+ func (f *File) GetSheetPrOptions(name string, opts ...SheetPrOptionPtr) error

+ func (f *File) GetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOptionPtr) error

+ func (f *File) SetSheetPrOptions(name string, opts ...SheetPrOption) error

+ func (f *File) SetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOption) error

+ type FitToPage bool

+ type Published bool

+ type RightToLeft bool

+ type SheetPrOption interface

+ type SheetPrOptionPtr interface

+ type SheetViewOption interface

+ type SheetViewOptionPtr interface

+ type ShowFormulas bool

+ type ShowGridLines bool

+ type ShowRowColHeaders bool

v1.1.0

Aug 19, 2017

Changes in this version

+ const Bar

+ const Bar3D

+ const Doughnut

+ const EMU

+ const Line

+ const NameSpaceDrawingML

+ const NameSpaceDrawingMLChart

+ const NameSpaceDrawingMLSpreadSheet

+ const NameSpaceSpreadSheet

+ const NameSpaceXML

+ const Pie

+ const Pie3D

+ const Radar

+ const Scatter

+ const SourceRelationship

+ const SourceRelationshipChart

+ const SourceRelationshipChart20070802

+ const SourceRelationshipChart2014

+ const SourceRelationshipChart201506

+ const SourceRelationshipComments

+ const SourceRelationshipCompatibility

+ const SourceRelationshipDrawingML

+ const SourceRelationshipDrawingVML

+ const SourceRelationshipHyperLink

+ const SourceRelationshipImage

+ const SourceRelationshipTable

+ const SourceRelationshipWorkSheet

+ const XMLHeader

+ func ReadZipReader(r *zip.Reader) (map[string]string, int, error)

+ func TitleToNumber(s string) int

+ func ToAlphaString(value int) string

+ type File struct

+ ContentTypes *xlsxTypes

+ Path string

+ SharedStrings *xlsxSST

+ Sheet map[string]*xlsxWorksheet

+ SheetCount int

+ Styles *xlsxStyleSheet

+ WorkBook *xlsxWorkbook

+ WorkBookRels *xlsxWorkbookRels

+ XLSX map[string]string

+ func NewFile() *File

+ func OpenFile(filename string) (*File, error)

+ func OpenReader(r io.Reader) (*File, error)

+ func (f *File) AddChart(sheet, cell, format string)

+ func (f *File) AddComment(sheet, cell, format string)

+ func (f *File) AddPicture(sheet, cell, picture, format string) error

+ func (f *File) AddShape(sheet, cell, format string)

+ func (f *File) AddTable(sheet, hcell, vcell, format string)

+ func (f *File) AutoFilter(sheet, hcell, vcell, format string) error

+ func (f *File) CopySheet(from, to int) error

+ func (f *File) DeleteSheet(name string)

+ func (f *File) GetActiveSheetIndex() int

+ func (f *File) GetCellFormula(sheet, axis string) string

+ func (f *File) GetCellHyperLink(sheet, axis string) (bool, string)

+ func (f *File) GetCellStyle(sheet, axis string) int

+ func (f *File) GetCellValue(sheet, axis string) string

+ func (f *File) GetColVisible(sheet, column string) bool

+ func (f *File) GetColWidth(sheet, column string) float64

+ func (f *File) GetPicture(sheet, cell string) (string, []byte)

+ func (f *File) GetRowHeight(sheet string, row int) float64

+ func (f *File) GetRowVisible(sheet string, rowIndex int) bool

+ func (f *File) GetRows(sheet string) [][]string

+ func (f *File) GetSheetIndex(name string) int

+ func (f *File) GetSheetMap() map[int]string

+ func (f *File) GetSheetName(index int) string

+ func (f *File) GetSheetVisible(name string) bool

+ func (f *File) InsertCol(sheet, column string)

+ func (f *File) InsertRow(sheet string, row int)

+ func (f *File) MergeCell(sheet, hcell, vcell string)

+ func (f *File) NewConditionalStyle(style string) (int, error)

+ func (f *File) NewSheet(index int, name string)

+ func (f *File) NewStyle(style string) (int, error)

+ func (f *File) RemoveCol(sheet, column string)

+ func (f *File) RemoveRow(sheet string, row int)

+ func (f *File) Save() error

+ func (f *File) SaveAs(name string) error

+ func (f *File) SetActiveSheet(index int)

+ func (f *File) SetCellDefault(sheet, axis, value string)

+ func (f *File) SetCellFormula(sheet, axis, formula string)

+ func (f *File) SetCellHyperLink(sheet, axis, link, linkType string)

+ func (f *File) SetCellInt(sheet, axis string, value int)

+ func (f *File) SetCellStr(sheet, axis, value string)

+ func (f *File) SetCellStyle(sheet, hcell, vcell string, styleID int)

+ func (f *File) SetCellValue(sheet, axis string, value interface{})

+ func (f *File) SetColVisible(sheet, column string, visible bool)

+ func (f *File) SetColWidth(sheet, startcol, endcol string, width float64)

+ func (f *File) SetConditionalFormat(sheet, area, formatSet string)

+ func (f *File) SetPanes(sheet, panes string)

+ func (f *File) SetRowHeight(sheet string, rowIndex int, height float64)

+ func (f *File) SetRowVisible(sheet string, rowIndex int, visible bool)

+ func (f *File) SetSheetBackground(sheet, picture string) error

+ func (f *File) SetSheetName(oldName, newName string)

+ func (f *File) SetSheetVisible(name string, visible bool)

+ func (f *File) UpdateLinkedValue()

+ func (f *File) Write(w io.Writer) error

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