excelize

package module

Go to main page

Versions in this module

v2

v2.8.1

Feb 25, 2024

Changes in this version

+ const ContentTypeRelationships

+ const ContentTypeSlicer

+ const ContentTypeSlicerCache

+ const ExtURICalcFeatures

+ const ExtURIDataModel

+ const ExtURIExternalLinkPr

+ const ExtURIModelTimeGroupings

+ const ExtURIPivotCacheDefinition

+ const ExtURIPivotCachesX14

+ const ExtURIPivotCachesX15

+ const ExtURIPivotTableReferences

+ const ExtURISlicerCacheDefinition

+ const ExtURISlicerCacheHideItemsWithNoData

+ const ExtURISlicerCachesX14

+ const ExtURISlicerCachesX15

+ const ExtURITimelineCachePivotCaches

+ const ExtURITimelineCacheRefs

+ const ExtURIWorkbookPrX14

+ const ExtURIWorkbookPrX15

+ const SourceRelationshipSlicer

+ const SourceRelationshipSlicerCache

+ var ErrFormControlValue = fmt.Errorf("scroll value must be between 0 and %d", MaxFormControlValue)

+ var NameSpaceDrawingMLA14 = xml.Attr

+ var NameSpaceDrawingMLSlicer = xml.Attr

+ var NameSpaceDrawingMLSlicerX15 = xml.Attr

+ var NameSpaceSpreadSheetXR10 = xml.Attr

type Chart

+ Border ChartLine

+ BubbleSize int

+ Fill Fill

+ type ChartDataLabelPositionType byte

+ const ChartDataLabelsPositionAbove

+ const ChartDataLabelsPositionBelow

+ const ChartDataLabelsPositionBestFit

+ const ChartDataLabelsPositionCenter

+ const ChartDataLabelsPositionInsideBase

+ const ChartDataLabelsPositionInsideEnd

+ const ChartDataLabelsPositionLeft

+ const ChartDataLabelsPositionOutsideEnd

+ const ChartDataLabelsPositionRight

+ const ChartDataLabelsPositionUnset

type ChartLine

+ Type ChartLineType

+ type ChartLineType byte

+ const ChartLineAutomatic

+ const ChartLineNone

+ const ChartLineSolid

type ChartMarker

+ Fill Fill

type ChartPlotArea

+ Fill Fill

type ChartSeries

+ DataLabelPosition ChartDataLabelPositionType

type Comment

+ Height uint

+ Width uint

type DataValidationType

+ const DataValidationTypeList

+ const DataValidationTypeNone

type File

+ DecodeCellImages *decodeCellImages

+ VolatileDeps *xlsxVolTypes

+ func (f *File) AddSlicer(sheet string, opts *SlicerOptions) error

+ func (f *File) DeletePivotTable(sheet, name string) error

+ func (f *File) GetBaseColor(hexColor string, indexedColor int, themeColor *int) string

+ func (f *File) GetConditionalStyle(idx int) (*Style, error)

+ func (f *File) GetHeaderFooter(sheet string) (*HeaderFooterOptions, error)

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

+ func (f *File) GetPivotTables(sheet string) ([]PivotTableOptions, error)

+ func (f *File) SetCellUint(sheet, cell string, value uint64) error

type PivotTableOptions

+ Name string

+ type SlicerOptions struct

+ Caption string

+ Cell string

+ DisplayHeader *bool

+ Format GraphicOptions

+ Height uint

+ ItemDesc bool

+ Macro string

+ Name string

+ TableName string

+ TableSheet string

+ Width uint

v2.8.0

Aug 27, 2023

Changes in this version

+ const MaxFormControlValue

+ var ErrExistsTableName = errors.New("the same name table already exists")

+ var ErrNameLength = fmt.Errorf("the name length exceeds the %d characters limit", MaxFieldLength)

+ var ErrorFormControlValue = fmt.Errorf("scroll value must be between 0 and %d", MaxFormControlValue)

type ChartAxis

+ Secondary bool

+ Title []RichTextRun

type Comment

+ Paragraph []RichTextRun

+ type CultureName byte

+ const CultureNameEnUS

+ const CultureNameUnknown

+ const CultureNameZhCN

type File

+ func (f *File) AddFormControl(sheet string, opts FormControl) error

+ func (f *File) DeleteFormControl(sheet, cell string) error

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

+ func (f *File) GetFormControls(sheet string) ([]FormControl, error)

+ func (f *File) GetPanes(sheet string) (Panes, error)

+ func (f *File) GetStyle(idx int) (*Style, error)

+ func (f *File) GetTables(sheet string) ([]Table, error)

+ type FormControl struct

+ Cell string

+ CellLink string

+ Checked bool

+ CurrentVal uint

+ Format GraphicOptions

+ Height uint

+ Horizontally bool

+ IncChange uint

+ Macro string

+ MaxVal uint

+ MinVal uint

+ PageChange uint

+ Paragraph []RichTextRun

+ Text string

+ Type FormControlType

+ Width uint

+ type FormControlType byte

+ const FormControlButton

+ const FormControlCheckBox

+ const FormControlGroupBox

+ const FormControlLabel

+ const FormControlNote

+ const FormControlOptionButton

+ const FormControlScrollBar

+ const FormControlSpinButton

type Options

+ CultureInfo CultureName

+ LongDatePattern string

+ LongTimePattern string

+ ShortDatePattern string

type Panes

+ Selection []Selection

+ type Selection struct

+ ActiveCell string

+ Pane string

+ SQRef string

type Shape

+ Cell string

v2.7.1

Apr 9, 2023

Changes in this version

+ const ExtURIConditionalFormattingRuleID

+ const NameSpaceDrawingMLMain

+ const NameSpaceExtendedProperties

+ const SourceRelationshipExtendProperties

+ const StrictNameSpaceDocumentPropertiesVariantTypes

+ const StrictNameSpaceDrawingMLMain

+ const StrictNameSpaceExtendedProperties

+ const StrictSourceRelationshipExtendProperties

+ var ErrCellStyles = fmt.Errorf("the cell styles exceeds the %d limit", MaxCellStyles)

+ var ErrTableNameLength = fmt.Errorf("the table name length exceeds the %d characters limit", MaxFieldLength)

type ChartAxis

+ NumFmt ChartNumFmt

+ type ChartNumFmt struct

+ CustomNumFmt string

+ SourceLinked bool

type ChartPlotArea

+ NumFmt ChartNumFmt

+ SecondPlotValues int

type ChartSeries

+ Fill Fill

+ Sizes string

+ type ChartType byte

+ const BarOfPie

+ const PieOfPie

type ConditionalFormatOptions

+ BarBorderColor string

+ BarDirection string

+ BarOnly bool

+ BarSolid bool

+ IconStyle string

+ IconsOnly bool

+ ReverseIcons bool

+ StopIfTrue bool

type File

+ func (f *File) GetPictures(sheet, cell string) ([]Picture, error)

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

+ func (f *File) SetSheetDimension(sheet string, rangeRef string) error

type GraphicOptions

+ AltText string

+ type Picture struct

+ Extension string

+ File []byte

+ Format *GraphicOptions

type Shape

+ Fill Fill

type ShapeLine

+ Color string

+ type Table struct

+ Name string

+ Range string

+ ShowColumnStripes bool

+ ShowFirstColumn bool

+ ShowHeaderRow *bool

+ ShowLastColumn bool

+ ShowRowStripes *bool

+ StyleName string

v2.7.0

Jan 7, 2023

Changes in this version

+ const ExtURISVG

+ const Line3D

+ const MaxSheetNameLength

+ var ErrExistsSheet = errors.New("the same name sheet already exists")

+ var ErrSheetNameBlank = errors.New("the sheet name can not be blank")

+ var ErrSheetNameInvalid = errors.New("the sheet can not contain any of the characters :\\/?*[or]")

+ var ErrSheetNameLength = fmt.Errorf("the sheet name length exceeds the %d characters limit", MaxSheetNameLength)

+ var ErrSheetNameSingleQuote = errors.New("the first or last character of the sheet name can not be a single quote")

+ var ErrStreamSetPanes = errors.New("must call the SetPanes function before the SetRow function")

+ var ErrUnprotectWorkbook = errors.New("workbook has set no protect")

+ var ErrUnprotectWorkbookPassword = errors.New("workbook protect password not match")

+ var IndexedColorMapping = []string

+ var NameSpaceDrawing2016SVG = xml.Attr

+ type AutoFilterListOptions struct

+ Column string

+ Value []int

+ type AutoFilterOptions struct

+ Column string

+ Expression string

+ FilterList []AutoFilterListOptions

type CellType

+ const CellTypeFormula

+ const CellTypeInlineString

+ const CellTypeSharedString

+ type Chart struct

+ Dimension ChartDimension

+ Format GraphicOptions

+ HoleSize int

+ Legend ChartLegend

+ PlotArea ChartPlotArea

+ Series []ChartSeries

+ ShowBlanksAs string

+ Title ChartTitle

+ Type string

+ VaryColors *bool

+ XAxis ChartAxis

+ YAxis ChartAxis

+ type ChartAxis struct

+ Font Font

+ LogBase float64

+ MajorGridLines bool

+ MajorUnit float64

+ Maximum *float64

+ Minimum *float64

+ MinorGridLines bool

+ None bool

+ ReverseOrder bool

+ TickLabelSkip int

+ type ChartDimension struct

+ Height uint

+ Width uint

+ type ChartLegend struct

+ Position string

+ ShowLegendKey bool

+ type ChartLine struct

+ Color string

+ Smooth bool

+ Width float64

+ type ChartMarker struct

+ Size int

+ Symbol string

+ type ChartPlotArea struct

+ ShowBubbleSize bool

+ ShowCatName bool

+ ShowLeaderLines bool

+ ShowPercent bool

+ ShowSerName bool

+ ShowVal bool

+ type ChartSeries struct

+ Categories string

+ Line ChartLine

+ Marker ChartMarker

+ Name string

+ Values string

+ type ChartTitle struct

+ Name string

type Comment

+ Cell string

+ Runs []RichTextRun

+ type ConditionalFormatOptions struct

+ AboveAverage bool

+ BarColor string

+ Criteria string

+ Format int

+ MaxColor string

+ MaxLength string

+ MaxType string

+ MaxValue string

+ Maximum string

+ MidColor string

+ MidType string

+ MidValue string

+ MinColor string

+ MinLength string

+ MinType string

+ MinValue string

+ Minimum string

+ Percent bool

+ Type string

+ Value string

type File

+ func (f *File) GetColStyle(sheet, col string) (int, error)

+ func (f *File) GetConditionalFormats(sheet string) (map[string][]ConditionalFormatOptions, error)

+ func (f *File) GetDataValidations(sheet string) ([]*DataValidation, error)

+ func (f *File) GetSheetProps(sheet string) (SheetPropsOptions, error)

+ func (f *File) GetSheetView(sheet string, viewIndex int) (ViewOptions, error)

+ func (f *File) GetWorkbookProps() (WorkbookPropsOptions, error)

+ func (f *File) InsertCols(sheet, col string, n int) error

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

+ func (f *File) ProtectWorkbook(opts *WorkbookProtectionOptions) error

+ func (f *File) SetSheetBackgroundFromBytes(sheet, extension string, picture []byte) error

+ func (f *File) SetSheetCol(sheet, cell string, slice interface{}) error

+ func (f *File) SetSheetProps(sheet string, opts *SheetPropsOptions) error

+ func (f *File) SetSheetView(sheet string, viewIndex int, opts *ViewOptions) error

+ func (f *File) SetWorkbookProps(opts *WorkbookPropsOptions) error

+ func (f *File) UnprotectWorkbook(password ...string) error

type Font

+ ColorIndexed int

+ ColorTheme *int

+ ColorTint float64

+ type GraphicOptions struct

+ AutoFit bool

+ Hyperlink string

+ HyperlinkType string

+ LockAspectRatio bool

+ Locked *bool

+ OffsetX int

+ OffsetY int

+ Positioning string

+ PrintObject *bool

+ ScaleX float64

+ ScaleY float64

+ type HeaderFooterOptions struct

+ AlignWithMargins bool

+ DifferentFirst bool

+ DifferentOddEven bool

+ EvenFooter string

+ EvenHeader string

+ FirstFooter string

+ FirstHeader string

+ OddFooter string

+ OddHeader string

+ ScaleWithDoc bool

+ type PageLayoutMarginsOptions struct

+ Bottom *float64

+ Footer *float64

+ Header *float64

+ Horizontally *bool

+ Left *float64

+ Right *float64

+ Top *float64

+ Vertically *bool

+ type PageLayoutOptions struct

+ AdjustTo *uint

+ BlackAndWhite *bool

+ FirstPageNumber *uint

+ FitToHeight *int

+ FitToWidth *int

+ Orientation *string

+ Size *int

+ type PaneOptions struct

+ ActiveCell string

+ Pane string

+ SQRef string

+ type Panes struct

+ ActivePane string

+ Freeze bool

+ Panes []PaneOptions

+ Split bool

+ TopLeftCell string

+ XSplit int

+ YSplit int

+ type PivotTableOptions struct

+ ColGrandTotals bool

+ Columns []PivotTableField

+ CompactData bool

+ Data []PivotTableField

+ DataRange string

+ Filter []PivotTableField

+ MergeItem bool

+ PageOverThenDown bool

+ PivotTableRange string

+ PivotTableStyleName string

+ RowGrandTotals bool

+ Rows []PivotTableField

+ ShowColHeaders bool

+ ShowColStripes bool

+ ShowDrill bool

+ ShowError bool

+ ShowLastColumn bool

+ ShowRowHeaders bool

+ ShowRowStripes bool

+ UseAutoFormatting bool

type RowOpts

+ OutlineLevel int

+ type Shape struct

+ Color ShapeColor

+ Format GraphicOptions

+ Height uint

+ Line ShapeLine

+ Macro string

+ Paragraph []ShapeParagraph

+ Type string

+ Width uint

+ type ShapeColor struct

+ Effect string

+ Fill string

+ Line string

+ type ShapeLine struct

+ Width *float64

+ type ShapeParagraph struct

+ Font Font

+ Text string

+ type SheetPropsOptions struct

+ AutoPageBreaks *bool

+ BaseColWidth *uint8

+ CodeName *string

+ CustomHeight *bool

+ DefaultColWidth *float64

+ DefaultRowHeight *float64

+ EnableFormatConditionsCalculation *bool

+ FitToPage *bool

+ OutlineSummaryBelow *bool

+ OutlineSummaryRight *bool

+ Published *bool

+ TabColorIndexed *int

+ TabColorRGB *string

+ TabColorTheme *int

+ TabColorTint *float64

+ ThickBottom *bool

+ ThickTop *bool

+ ZeroHeight *bool

+ type SheetProtectionOptions struct

+ AlgorithmName string

+ 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 SparklineOptions struct

+ Axis bool

+ CustMax int

+ CustMin int

+ DateAxis bool

+ EmptyCells string

+ First bool

+ FirstColor string

+ Hidden bool

+ High bool

+ HightColor string

+ Last bool

+ LastColor string

+ Location []string

+ Low bool

+ LowColor string

+ Markers bool

+ MarkersColor string

+ Max int

+ Min int

+ Negative bool

+ NegativeColor string

+ Range []string

+ Reverse bool

+ SeriesColor string

+ Style int

+ Type string

+ Weight float64

type StreamWriter

+ func (sw *StreamWriter) InsertPageBreak(cell string) error

+ func (sw *StreamWriter) SetPanes(panes *Panes) error

+ type TableOptions struct

+ Name string

+ ShowColumnStripes bool

+ ShowFirstColumn bool

+ ShowLastColumn bool

+ ShowRowStripes *bool

+ StyleName string

+ type ViewOptions struct

+ DefaultGridColor *bool

+ RightToLeft *bool

+ ShowFormulas *bool

+ ShowGridLines *bool

+ ShowRowColHeaders *bool

+ ShowRuler *bool

+ ShowZeros *bool

+ TopLeftCell *string

+ View *string

+ ZoomScale *float64

+ type WorkbookPropsOptions struct

+ CodeName *string

+ Date1904 *bool

+ FilterPrivacy *bool

+ type WorkbookProtectionOptions struct

+ AlgorithmName string

+ LockStructure bool

+ LockWindows bool

+ Password string

v2.6.1

Aug 20, 2022

Changes in this version

+ const ColorMappingTypeAccent1

+ const ColorMappingTypeAccent2

+ const ColorMappingTypeAccent3

+ const ColorMappingTypeAccent4

+ const ColorMappingTypeAccent5

+ const ColorMappingTypeAccent6

+ const ColorMappingTypeDark1

+ const ColorMappingTypeDark2

+ const ColorMappingTypeFollowedHyperlink

+ const ColorMappingTypeHyperlink

+ const ColorMappingTypeLight1

+ const ColorMappingTypeLight2

+ const ColorMappingTypeUnset

+ const MaxCellStyles

+ const MaxColumns

+ const MaxFilePathLength

+ const MinColumns

+ const MinFontSize

+ var ErrMaxFilePathLength = errors.New("file path length exceeds maximum limit")

+ var ErrWorkbookFileFormat = errors.New("unsupported workbook file format")

+ var ErrWorkbookPassword = errors.New("the supplied open workbook password is not correct")

+ type ColorMappingType byte

+ type Date1904 bool

type File

+ func (f *File) DeleteComment(sheet, cell string) (err error)

type Font

+ VertAlign string

type Options

+ MaxCalcIterations uint

type Rows

+ func (rows *Rows) GetRowOpts() RowOpts

+ type TabColorIndexed int

+ type TabColorRGB string

+ type TabColorTheme int

+ type TabColorTint float64

v2.6.0

Apr 10, 2022

Changes in this version

+ const ContentTypeAddinMacro

+ const ContentTypeSheetML

+ const ContentTypeTemplate

+ const ContentTypeTemplateMacro

+ const DataValidationTypeTextLength

+ const NameSpaceDublinCoreMetadataInitiative

+ var ErrDataValidationFormulaLength = errors.New("data validation must be 0-255 characters")

+ var ErrDefinedNameDuplicate = errors.New("the same name already exists on the scope")

+ var ErrPasswordLengthInvalid = errors.New("password length invalid")

+ var ErrUnprotectSheet = errors.New("worksheet has set no protect")

+ var ErrUnprotectSheetPassword = errors.New("worksheet protect password not match")

+ var ErrUnsupportedEncryptMechanism = errors.New("unsupported encryption mechanism")

+ var ErrUnsupportedHashAlgorithm = errors.New("unsupported hash algorithm")

+ var ErrUnsupportedNumberFormat = errors.New("unsupported number format token")

+ var ErrWorkbookExt = errors.New("unsupported workbook extension")

type File

+ func (f *File) GetWorkbookPrOptions(opts ...WorkbookPrOptionPtr) error

+ func (f *File) SetWorkbookPrOptions(opts ...WorkbookPrOption) error

+ type FilterPrivacy bool

type FormatSheetProtection

+ AlgorithmName string

+ type ShowRuler bool

+ type View string

+ type WorkbookPrOption interface

+ type WorkbookPrOptionPtr interface

v2.5.0

Dec 30, 2021

Changes in this version

+ const MaxFieldLength

+ const UnzipSizeLimit

+ var ErrAttrValBool = errors.New("unexpected child of attrValBool")

+ var ErrCustomNumFmt = errors.New("custom number format can not be empty")

+ var ErrMaxRows = errors.New("row number exceeds maximum limit")

+ var ErrOptionsUnzipSizeLimit = errors.New(...)

+ var ErrSave = errors.New("no path defined for file, consider File.WriteTo or File.Write")

+ var ErrSparkline = errors.New("must have the same number of 'Location' and 'Range' parameters")

+ var ErrSparklineLocation = errors.New("parameter 'Location' is required")

+ var ErrSparklineRange = errors.New("parameter 'Range' is required")

+ var ErrSparklineStyle = errors.New("parameter 'Style' must betweent 0-35")

+ var ErrSparklineType = errors.New("parameter 'Type' must be 'line', 'column' or 'win_loss'")

+ var NameSpaceDocumentPropertiesVariantTypes = xml.Attr

+ type AppProperties struct

+ AppVersion string

+ Application string

+ Company string

+ DocSecurity int

+ HyperlinksChanged bool

+ LinksUpToDate bool

+ ScaleCrop bool

+ type CellType byte

+ const CellTypeBool

+ const CellTypeDate

+ const CellTypeError

+ const CellTypeNumber

+ const CellTypeString

+ const CellTypeUnset

type Cols

+ func (cols *Cols) CurrentCol() int

+ func (cols *Cols) TotalCols() int

type File

+ func (f *File) Close() error

+ func (f *File) GetAppProps() (ret *AppProperties, err error)

+ func (f *File) GetCellType(sheet, axis string) (CellType, error)

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

+ func (f *File) SetAppProps(appProperties *AppProperties) (err error)

+ func (f *File) SetRowStyle(sheet string, start, end, styleID int) error

type Options

+ RawCellValue bool

+ UnzipSizeLimit int64

+ UnzipXMLSizeLimit int64

type PivotTableField

+ Compact bool

+ Outline bool

type RowOpts

+ StyleID int

type Rows

+ func (rows *Rows) Close() error

+ func (rows *Rows) CurrentRow() int

+ func (rows *Rows) TotalRows() int

v2.4.1

Aug 1, 2021

Changes in this version

+ const Area

+ const Area3D

+ const Area3DPercentStacked

+ const Area3DStacked

+ const AreaPercentStacked

+ const AreaStacked

+ const Bar

+ const Bar3DClustered

+ const Bar3DConeClustered

+ const Bar3DConePercentStacked

+ const Bar3DConeStacked

+ const Bar3DCylinderClustered

+ const Bar3DCylinderPercentStacked

+ const Bar3DCylinderStacked

+ const Bar3DPercentStacked

+ const Bar3DPyramidClustered

+ const Bar3DPyramidPercentStacked

+ const Bar3DPyramidStacked

+ const Bar3DStacked

+ const BarOfPieChart

+ const BarPercentStacked

+ const BarStacked

+ const Bubble

+ const Bubble3D

+ const Col

+ const Col3D

+ const Col3DClustered

+ const Col3DCone

+ const Col3DConeClustered

+ const Col3DConePercentStacked

+ const Col3DConeStacked

+ const Col3DCylinder

+ const Col3DCylinderClustered

+ const Col3DCylinderPercentStacked

+ const Col3DCylinderStacked

+ const Col3DPercentStacked

+ const Col3DPyramid

+ const Col3DPyramidClustered

+ const Col3DPyramidPercentStacked

+ const Col3DPyramidStacked

+ const Col3DStacked

+ const ColPercentStacked

+ const ColStacked

+ const ContentTypeDrawing

+ const ContentTypeDrawingML

+ const ContentTypeMacro

+ const ContentTypeSpreadSheetMLChartsheet

+ const ContentTypeSpreadSheetMLComments

+ const ContentTypeSpreadSheetMLPivotCacheDefinition

+ const ContentTypeSpreadSheetMLPivotTable

+ const ContentTypeSpreadSheetMLSharedStrings

+ const ContentTypeSpreadSheetMLTable

+ const ContentTypeSpreadSheetMLWorksheet

+ const ContentTypeVBA

+ const ContentTypeVML

+ const Contour

+ 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 Doughnut

+ const EMU

+ const ExtURIConditionalFormattings

+ const ExtURIDataValidations

+ const ExtURIDrawingBlip

+ const ExtURIIgnoredErrors

+ const ExtURIMacExcelMX

+ const ExtURIProtectedRanges

+ const ExtURISlicerCachesListX14

+ const ExtURISlicerListX14

+ const ExtURISlicerListX15

+ const ExtURISparklineGroups

+ const ExtURITimelineRefs

+ const ExtURIWebExtensions

+ const Line

+ const MaxColumnWidth

+ const MaxFileNameLength

+ const MaxFontFamilyLength

+ const MaxFontSize

+ const MaxRowHeight

+ const NameSpaceDublinCore

+ const NameSpaceDublinCoreMetadataIntiative

+ const NameSpaceDublinCoreTerms

+ const NameSpaceXML

+ const NameSpaceXMLSchemaInstance

+ const OrientationLandscape

+ const OrientationPortrait

+ const Pie

+ const Pie3D

+ const PieOfPieChart

+ const Radar

+ const STCellFormulaTypeArray

+ const STCellFormulaTypeDataTable

+ const STCellFormulaTypeNormal

+ const STCellFormulaTypeShared

+ const Scatter

+ const SourceRelationshipChart

+ const SourceRelationshipChartsheet

+ const SourceRelationshipComments

+ const SourceRelationshipDialogsheet

+ const SourceRelationshipDrawingML

+ const SourceRelationshipDrawingVML

+ const SourceRelationshipHyperLink

+ const SourceRelationshipImage

+ const SourceRelationshipOfficeDocument

+ const SourceRelationshipPivotCache

+ const SourceRelationshipPivotTable

+ const SourceRelationshipSharedStrings

+ const SourceRelationshipTable

+ const SourceRelationshipVBAProject

+ const SourceRelationshipWorkSheet

+ const StreamChunkSize

+ const StrictNameSpaceSpreadSheet

+ const StrictSourceRelationship

+ const StrictSourceRelationshipChart

+ const StrictSourceRelationshipComments

+ const StrictSourceRelationshipImage

+ const StrictSourceRelationshipOfficeDocument

+ const Surface3D

+ const TotalCellChars

+ const TotalColumns

+ const TotalRows

+ const TotalSheetHyperlinks

+ const WireframeContour

+ const WireframeSurface3D

+ const XMLHeader

+ var ErrAddVBAProject = errors.New("unsupported VBA project extension")

+ var ErrCellCharsLength = fmt.Errorf("cell value must be 0-%d characters", TotalCellChars)

+ var ErrColumnNumber = errors.New("column number exceeds maximum limit")

+ var ErrColumnWidth = fmt.Errorf("the width of the column must be smaller than or equal to %d characters", ...)

+ var ErrCoordinates = errors.New("coordinates length must be 4")

+ var ErrDataValidationFormulaLenth = errors.New("data validation must be 0-255 characters")

+ var ErrDataValidationRange = errors.New("data validation range exceeds limit")

+ var ErrDefinedNameScope = errors.New("no defined name on the scope")

+ var ErrDefinedNameduplicate = errors.New("the same name already exists on the scope")

+ var ErrEncrypt = errors.New("not support encryption currently")

+ var ErrExistsWorksheet = errors.New("the same name worksheet already exists")

+ var ErrFontLength = errors.New("the length of the font family name must be smaller than or equal to 31")

+ var ErrFontSize = errors.New("font size must be between 1 and 409 points")

+ var ErrGroupSheets = errors.New("group worksheet must contain an active worksheet")

+ var ErrImgExt = errors.New("unsupported image extension")

+ var ErrInvalidFormula = errors.New("formula not valid")

+ var ErrMaxFileNameLength = errors.New("file name length exceeds maximum limit")

+ var ErrMaxRowHeight = errors.New("the height of the row must be smaller than or equal to 409 points")

+ var ErrOutlineLevel = errors.New("invalid outline level")

+ var ErrParameterInvalid = errors.New("parameter is invalid")

+ var ErrParameterRequired = errors.New("parameter is required")

+ var ErrSheetIdx = errors.New("invalid worksheet index")

+ var ErrStreamSetColWidth = errors.New("must call the SetColWidth function before the SetRow function")

+ var ErrToExcelTime = errors.New("only UTC time expected")

+ var ErrTotalSheetHyperlinks = errors.New("over maximum limit hyperlinks in a worksheet")

+ var ErrUnknownEncryptMechanism = errors.New("unknown encryption mechanism")

+ var ErrUnsupportEncryptMechanism = errors.New("unsupport encryption mechanism")

+ var HSLModel = color.ModelFunc(hslModel)

+ var NameSpaceDrawingML = xml.Attr

+ var NameSpaceDrawingMLChart = xml.Attr

+ var NameSpaceDrawingMLSpreadSheet = xml.Attr

+ var NameSpaceMacExcel2008Main = xml.Attr

+ var NameSpaceSpreadSheet = xml.Attr

+ var NameSpaceSpreadSheetExcel2006Main = xml.Attr

+ var NameSpaceSpreadSheetX14 = xml.Attr

+ var NameSpaceSpreadSheetX15 = xml.Attr

+ var SourceRelationship = xml.Attr

+ var SourceRelationshipChart20070802 = xml.Attr

+ var SourceRelationshipChart2014 = xml.Attr

+ var SourceRelationshipChart201506 = xml.Attr

+ var SourceRelationshipCompatibility = xml.Attr

+ var XMLHeaderByte = []byte(XMLHeader)

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

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

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

+ func CoordinatesToCellName(col, row int, abs ...bool) (string, error)

+ func Decrypt(raw []byte, opt *Options) (packageBuf []byte, err error)

+ func Encrypt(raw []byte, opt *Options) (packageBuf []byte, err error)

+ func ExcelDateToTime(excelDate float64, use1904Format bool) (time.Time, error)

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

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

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

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

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

+ func ThemeColor(baseColor string, tint float64) string

+ type Alignment struct

+ Horizontal string

+ Indent int

+ JustifyLastLine bool

+ ReadingOrder uint64

+ RelativeIndent int

+ ShrinkToFit bool

+ TextRotation int

+ Vertical string

+ WrapText bool

+ type ArgType byte

+ const ArgEmpty

+ const ArgError

+ const ArgList

+ const ArgMatrix

+ const ArgNumber

+ const ArgString

+ const ArgUnknown

+ type AutoPageBreaks bool

+ type BaseColWidth uint8

+ type BlackAndWhite bool

+ type Border struct

+ Color string

+ Style int

+ Type string

+ type Cell struct

+ Formula string

+ StyleID int

+ Value interface{}

+ type CodeName string

+ type Cols struct

+ func (cols *Cols) Error() error

+ func (cols *Cols) Next() bool

+ func (cols *Cols) Rows() ([]string, error)

+ type Comment struct

+ Author string

+ AuthorID int

+ Ref string

+ Text string

+ type CustomHeight bool

+ type DataIntegrity struct

+ EncryptedHmacKey string

+ EncryptedHmacValue 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 float64, 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 DefaultColWidth float64

+ type DefaultGridColor bool

+ type DefaultRowHeight float64

+ type DefinedName struct

+ Comment string

+ Name string

+ RefersTo string

+ Scope string

+ type DocProperties struct

+ Category string

+ ContentStatus string

+ Created string

+ Creator string

+ Description string

+ Identifier string

+ Keywords string

+ Language string

+ LastModifiedBy string

+ Modified string

+ Revision string

+ Subject string

+ Title string

+ Version string

+ type EnableFormatConditionsCalculation bool

+ type EncryptedKey struct

+ EncryptedKeyValue string

+ EncryptedVerifierHashInput string

+ EncryptedVerifierHashValue string

+ SpinCount int

+ XMLName xml.Name

+ type Encryption struct

+ DataIntegrity DataIntegrity

+ KeyData KeyData

+ KeyEncryptors KeyEncryptors

+ XMLName xml.Name

+ type ErrSheetNotExist struct

+ SheetName string

+ func (err ErrSheetNotExist) Error() string

+ type File struct

+ CalcChain *xlsxCalcChain

+ CharsetReader charsetTranscoderFn

+ Comments map[string]*xlsxComments

+ ContentTypes *xlsxTypes

+ DecodeVMLDrawing map[string]*decodeVmlDrawing

+ Drawings sync.Map

+ Path string

+ Pkg sync.Map

+ Relationships sync.Map

+ SharedStrings *xlsxSST

+ Sheet sync.Map

+ SheetCount int

+ Styles *xlsxStyleSheet

+ Theme *xlsxTheme

+ VMLDrawing map[string]*vmlDrawing

+ WorkBook *xlsxWorkbook

+ func NewFile() *File

+ func OpenFile(filename string, opt ...Options) (*File, error)

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

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

+ func (f *File) AddChartSheet(sheet, format string, combo ...string) error

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

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

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

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

+ func (f *File) AddPivotTable(opt *PivotTableOption) error

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

+ func (f *File) AddSparkline(sheet string, opt *SparklineOption) (err error)

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

+ func (f *File) AddVBAProject(bin string) error

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

+ func (f *File) CalcCellValue(sheet, cell string) (result string, err error)

+ func (f *File) CharsetTranscoder(fn charsetTranscoderFn) *File

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

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

+ func (f *File) DeleteChart(sheet, cell string) (err error)

+ func (f *File) DeleteDataValidation(sheet, sqref string) error

+ func (f *File) DeleteDefinedName(definedName *DefinedName) error

+ func (f *File) DeletePicture(sheet, cell string) (err error)

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

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

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

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

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

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

+ func (f *File) GetCellRichText(sheet, cell string) (runs []RichTextRun, err error)

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

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

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

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

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

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

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

+ func (f *File) GetDefaultFont() string

+ func (f *File) GetDefinedName() []DefinedName

+ func (f *File) GetDocProps() (ret *DocProperties, err error)

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

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

+ func (f *File) GetPageMargins(sheet string, opts ...PageMarginsOptionsPtr) error

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

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

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

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

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

+ func (f *File) GetSheetFormatPr(sheet string, opts ...SheetFormatPrOptionsPtr) error

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

+ func (f *File) GetSheetList() (list []string)

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

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

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

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

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

+ func (f *File) GroupSheets(sheets []string) error

+ func (f *File) InsertCol(sheet, col string) error

+ func (f *File) InsertPageBreak(sheet, cell string) (err error)

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

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

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

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

+ func (f *File) NewStreamWriter(sheet string) (*StreamWriter, error)

+ func (f *File) NewStyle(style interface{}) (int, error)

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

+ func (f *File) RemoveCol(sheet, col string) error

+ func (f *File) RemovePageBreak(sheet, cell string) (err error)

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

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

+ func (f *File) Save() error

+ func (f *File) SaveAs(name string, opt ...Options) error

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

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

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

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

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

+ func (f *File) SetCellFormula(sheet, axis, formula string, opts ...FormulaOpts) error

+ func (f *File) SetCellHyperLink(sheet, axis, link, linkType string, opts ...HyperlinkOpts) error

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

+ func (f *File) SetCellRichText(sheet, cell string, runs []RichTextRun) error

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

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

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

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

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

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

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

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

+ func (f *File) SetDefaultFont(fontName string)

+ func (f *File) SetDefinedName(definedName *DefinedName) error

+ func (f *File) SetDocProps(docProperties *DocProperties) (err error)

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

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

+ func (f *File) SetPageMargins(sheet string, opts ...PageMarginsOptions) error

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

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

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

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

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

+ func (f *File) SetSheetFormatPr(sheet string, opts ...SheetFormatPrOptions) error

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

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

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

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

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

+ func (f *File) UngroupSheets() error

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

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

+ func (f *File) UnsetConditionalFormat(sheet, area string) error

+ func (f *File) UpdateLinkedValue() error

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

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

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

+ type Fill struct

+ Color []string

+ Pattern int

+ Shading int

+ Type string

+ type FirstPageNumber uint

+ type FitToHeight int

+ type FitToPage bool

+ type FitToWidth int

+ type Font struct

+ Bold bool

+ Color string

+ Family string

+ Italic bool

+ Size float64

+ Strike bool

+ Underline string

+ type FormatHeaderFooter struct

+ AlignWithMargins bool

+ DifferentFirst bool

+ DifferentOddEven bool

+ EvenFooter string

+ EvenHeader string

+ FirstFooter string

+ FirstHeader string

+ OddFooter string

+ OddHeader string

+ ScaleWithDoc bool

+ type FormatPageMargins struct

+ Bottom string

+ Footer string

+ Header string

+ Left string

+ Right string

+ Top string

+ 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 FormulaOpts struct

+ Ref *string

+ Type *string

+ type HSL struct

+ H float64

+ L float64

+ S float64

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

+ type HyperlinkOpts struct

+ Display *string

+ Tooltip *string

+ type KeyData struct

+ BlockSize int

+ CipherAlgorithm string

+ CipherChaining string

+ HashAlgorithm string

+ HashSize int

+ KeyBits int

+ SaltSize int

+ SaltValue string

+ type KeyEncryptor struct

+ EncryptedKey EncryptedKey

+ URI string

+ XMLName xml.Name

+ type KeyEncryptors struct

+ KeyEncryptor []KeyEncryptor

+ type MergeCell []string

+ func (m *MergeCell) GetCellValue() string

+ func (m *MergeCell) GetEndAxis() string

+ func (m *MergeCell) GetStartAxis() string

+ type Options struct

+ Password string

+ type OutlineSummaryBelow bool

+ type PageLayoutOption interface

+ type PageLayoutOptionPtr interface

+ type PageLayoutOrientation string

+ type PageLayoutPaperSize int

+ type PageLayoutScale uint

+ type PageMarginBottom float64

+ type PageMarginFooter float64

+ type PageMarginHeader float64

+ type PageMarginLeft float64

+ type PageMarginRight float64

+ type PageMarginTop float64

+ type PageMarginsOptions interface

+ type PageMarginsOptionsPtr interface

+ type PivotTableField struct

+ Data string

+ DefaultSubtotal bool

+ Name string

+ Subtotal string

+ type PivotTableOption struct

+ ColGrandTotals bool

+ Columns []PivotTableField

+ CompactData bool

+ Data []PivotTableField

+ DataRange string

+ Filter []PivotTableField

+ MergeItem bool

+ PageOverThenDown bool

+ PivotTableRange string

+ PivotTableStyleName string

+ RowGrandTotals bool

+ Rows []PivotTableField

+ ShowColHeaders bool

+ ShowColStripes bool

+ ShowDrill bool

+ ShowError bool

+ ShowLastColumn bool

+ ShowRowHeaders bool

+ ShowRowStripes bool

+ UseAutoFormatting bool

+ type Protection struct

+ Hidden bool

+ Locked bool

+ type Published bool

+ type RichTextRun struct

+ Font *Font

+ Text string

+ type RightToLeft bool

+ type RowOpts struct

+ Height float64

+ Hidden bool

+ type Rows struct

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

+ func (rows *Rows) Error() error

+ func (rows *Rows) Next() bool

+ type SheetFormatPrOptions interface

+ type SheetFormatPrOptionsPtr interface

+ type SheetPrOption interface

+ type SheetPrOptionPtr interface

+ type SheetViewOption interface

+ type SheetViewOptionPtr interface

+ type ShowFormulas bool

+ type ShowGridLines bool

+ type ShowRowColHeaders bool

+ type ShowZeros bool

+ type SparklineOption struct

+ Axis bool

+ CustMax int

+ CustMin int

+ DateAxis bool

+ EmptyCells string

+ First bool

+ FirstColor string

+ Hidden bool

+ High bool

+ HightColor string

+ Last bool

+ LastColor string

+ Location []string

+ Low bool

+ LowColor string

+ Markers bool

+ MarkersColor string

+ Max int

+ Min int

+ Negative bool

+ NegativeColor string

+ Range []string

+ Reverse bool

+ SeriesColor string

+ Style int

+ Type string

+ Weight float64

+ type Stack struct

+ func NewStack() *Stack

+ func (stack *Stack) Empty() bool

+ func (stack *Stack) Len() int

+ func (stack *Stack) Peek() interface{}

+ func (stack *Stack) Pop() interface{}

+ func (stack *Stack) Push(value interface{})

+ type StandardEncryptionHeader struct

+ AlgID uint32

+ AlgIDHash uint32

+ CspName string

+ Flags uint32

+ KeySize uint32

+ ProviderType uint32

+ Reserved1 uint32

+ Reserved2 uint32

+ SizeExtra uint32

+ type StandardEncryptionVerifier struct

+ EncryptedVerifier []byte

+ EncryptedVerifierHash []byte

+ Salt []byte

+ SaltSize uint32

+ VerifierHashSize uint32

+ type StreamWriter struct

+ File *File

+ Sheet string

+ SheetID int

+ func (sw *StreamWriter) AddTable(hcell, vcell, format string) error

+ func (sw *StreamWriter) Flush() error

+ func (sw *StreamWriter) MergeCell(hcell, vcell string) error

+ func (sw *StreamWriter) SetColWidth(min, max int, width float64) error

+ func (sw *StreamWriter) SetRow(axis string, values []interface{}, opts ...RowOpts) error

+ type Style struct

+ Alignment *Alignment

+ Border []Border

+ CustomNumFmt *string

+ DecimalPlaces int

+ Fill Fill

+ Font *Font

+ Lang string

+ NegRed bool

+ NumFmt int

+ Protection *Protection

+ type TabColor string

+ type ThickBottom bool

+ type ThickTop bool

+ type TopLeftCell string

+ type ZeroHeight bool

+ type ZoomScale float64

Other modules containing this package

github.com/xuri/excelize

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