Versions in this module Expand all Collapse all v2 v2.8.6 Sep 12, 2024 v2.8.5 Sep 12, 2024 v2.8.4 Sep 12, 2024 Changes in this version type PivotTableField + NumFmt int v2.8.3 Jul 24, 2024 Changes in this version type File + func (f *File) GetCellPixelsWithCoordinates(sheet, cell string) (cellWidth, cellHeight, c, r int, err error) v2.8.2 Jul 24, 2024 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 ContentTypeAddinMacro + const ContentTypeDrawing + const ContentTypeDrawingML + const ContentTypeMacro + const ContentTypeRelationships + const ContentTypeSheetML + const ContentTypeSlicer + const ContentTypeSlicerCache + const ContentTypeSpreadSheetMLChartsheet + const ContentTypeSpreadSheetMLComments + const ContentTypeSpreadSheetMLPivotCacheDefinition + const ContentTypeSpreadSheetMLPivotTable + const ContentTypeSpreadSheetMLSharedStrings + const ContentTypeSpreadSheetMLTable + const ContentTypeSpreadSheetMLWorksheet + const ContentTypeTemplate + const ContentTypeTemplateMacro + const ContentTypeVBA + const ContentTypeVML + const EMU + const ExtURICalcFeatures + const ExtURIConditionalFormattingRuleID + const ExtURIConditionalFormattings + const ExtURIDataModel + const ExtURIDataValidations + const ExtURIDrawingBlip + const ExtURIExternalLinkPr + const ExtURIIgnoredErrors + const ExtURIMacExcelMX + const ExtURIModelTimeGroupings + const ExtURIPivotCacheDefinition + const ExtURIPivotCachesX14 + const ExtURIPivotCachesX15 + const ExtURIPivotTableReferences + const ExtURIProtectedRanges + const ExtURISVG + const ExtURISlicerCacheDefinition + const ExtURISlicerCacheHideItemsWithNoData + const ExtURISlicerCachesX14 + const ExtURISlicerCachesX15 + const ExtURISlicerListX14 + const ExtURISlicerListX15 + const ExtURISparklineGroups + const ExtURITimelineCachePivotCaches + const ExtURITimelineCacheRefs + const ExtURITimelineRefs + const ExtURIWebExtensions + const ExtURIWorkbookPrX14 + const ExtURIWorkbookPrX15 + const MaxCellStyles + const MaxColumnWidth + const MaxColumns + const MaxFieldLength + const MaxFilePathLength + const MaxFontFamilyLength + const MaxFontSize + const MaxFormControlValue + const MaxRowHeight + const MaxSheetNameLength + const MinColumns + const MinFontSize + const NameSpaceDrawingMLMain + const NameSpaceDublinCore + const NameSpaceDublinCoreMetadataInitiative + const NameSpaceDublinCoreTerms + const NameSpaceExtendedProperties + const NameSpaceXML + const NameSpaceXMLSchemaInstance + const STCellFormulaTypeArray + const STCellFormulaTypeDataTable + const STCellFormulaTypeNormal + const STCellFormulaTypeShared + const SourceRelationshipChart + const SourceRelationshipChartsheet + const SourceRelationshipComments + const SourceRelationshipDialogsheet + const SourceRelationshipDrawingML + const SourceRelationshipDrawingVML + const SourceRelationshipExtendProperties + const SourceRelationshipHyperLink + const SourceRelationshipImage + const SourceRelationshipOfficeDocument + const SourceRelationshipPivotCache + const SourceRelationshipPivotTable + const SourceRelationshipSharedStrings + const SourceRelationshipSlicer + const SourceRelationshipSlicerCache + const SourceRelationshipTable + const SourceRelationshipVBAProject + const SourceRelationshipWorkSheet + const StreamChunkSize + const StrictNameSpaceDocumentPropertiesVariantTypes + const StrictNameSpaceDrawingMLMain + const StrictNameSpaceExtendedProperties + const StrictNameSpaceSpreadSheet + const StrictSourceRelationship + const StrictSourceRelationshipChart + const StrictSourceRelationshipComments + const StrictSourceRelationshipExtendProperties + const StrictSourceRelationshipImage + const StrictSourceRelationshipOfficeDocument + const TotalCellChars + const TotalRows + const TotalSheetHyperlinks + const UnzipSizeLimit + var ErrAddVBAProject = errors.New("unsupported VBA project") + var ErrAttrValBool = errors.New("unexpected child of attrValBool") + var ErrCellCharsLength = fmt.Errorf("cell value must be 0-%d characters", TotalCellChars) + var ErrCellStyles = fmt.Errorf("the cell styles exceeds the %d limit", MaxCellStyles) + var ErrColumnNumber = fmt.Errorf(...) + var ErrColumnWidth = fmt.Errorf("the width of the column must be less than or equal to %d characters", ...) + var ErrCoordinates = errors.New("coordinates length must be 4") + var ErrCustomNumFmt = errors.New("custom number format can not be empty") + var ErrDataValidationFormulaLength = fmt.Errorf("data validation must be 0-%d characters", MaxFieldLength) + var ErrDataValidationRange = errors.New("data validation range exceeds limit") + var ErrDefinedNameDuplicate = errors.New("the same name already exists on the scope") + var ErrDefinedNameScope = errors.New("no defined name on the scope") + var ErrExistsSheet = errors.New("the same name sheet already exists") + var ErrExistsTableName = errors.New("the same name table already exists") + var ErrFontLength = fmt.Errorf("the length of the font family name must be less than or equal to %d", ...) + var ErrFontSize = fmt.Errorf("font size must be between %d and %d points", MinFontSize, MaxFontSize) + var ErrFormControlValue = fmt.Errorf("scroll value must be between 0 and %d", MaxFormControlValue) + 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 ErrMaxFilePathLength = fmt.Errorf("file path length exceeds maximum limit %d characters", MaxFilePathLength) + var ErrMaxRowHeight = fmt.Errorf("the height of the row must be less than or equal to %d points", MaxRowHeight) + var ErrMaxRows = errors.New("row number exceeds maximum limit") + var ErrNameLength = fmt.Errorf("the name length exceeds the %d characters limit", MaxFieldLength) + var ErrOptionsUnzipSizeLimit = errors.New(...) + var ErrOutlineLevel = errors.New("invalid outline level") + var ErrParameterInvalid = errors.New("parameter is invalid") + var ErrParameterRequired = errors.New("parameter is required") + var ErrPasswordLengthInvalid = errors.New("password length invalid") + var ErrSave = errors.New("no path defined for file, consider File.WriteTo or File.Write") + var ErrSheetIdx = errors.New("invalid worksheet index") + 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 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 between 0-35") + var ErrSparklineType = errors.New("parameter 'Type' must be 'line', 'column' or 'win_loss'") + var ErrStreamSetColWidth = errors.New("must call the SetColWidth function before the SetRow function") + var ErrStreamSetPanes = errors.New("must call the SetPanes function before the SetRow function") + var ErrTotalSheetHyperlinks = errors.New("over maximum limit hyperlinks in a worksheet") + var ErrUnknownEncryptMechanism = errors.New("unknown encryption mechanism") + var ErrUnprotectSheet = errors.New("worksheet has set no protect") + var ErrUnprotectSheetPassword = errors.New("worksheet protect password not match") + var ErrUnprotectWorkbook = errors.New("workbook has set no protect") + var ErrUnprotectWorkbookPassword = errors.New("workbook 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 ErrWorkbookFileFormat = errors.New("unsupported workbook file format") + var ErrWorkbookPassword = errors.New("the supplied open workbook password is not correct") + var HSLModel = color.ModelFunc(hslModel) + var IndexedColorMapping = []string + var NameSpaceDocumentPropertiesVariantTypes = xml.Attr + var NameSpaceDrawing2016SVG = xml.Attr + var NameSpaceDrawingML = xml.Attr + var NameSpaceDrawingMLA14 = xml.Attr + var NameSpaceDrawingMLChart = xml.Attr + var NameSpaceDrawingMLSlicer = xml.Attr + var NameSpaceDrawingMLSlicerX15 = 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 NameSpaceSpreadSheetXR10 = xml.Attr + var SourceRelationship = xml.Attr + var SourceRelationshipChart20070802 = xml.Attr + var SourceRelationshipChart2014 = xml.Attr + var SourceRelationshipChart201506 = xml.Attr + var SourceRelationshipCompatibility = xml.Attr + 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, opts *Options) (packageBuf []byte, err error) + func Encrypt(raw []byte, opts *Options) ([]byte, 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 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 AppProperties struct + AppVersion string + Application string + Company string + DocSecurity int + HyperlinksChanged bool + LinksUpToDate bool + ScaleCrop bool + type ArgType byte + const ArgEmpty + const ArgError + const ArgList + const ArgMatrix + const ArgNumber + const ArgString + const ArgUnknown + type AutoFilterOptions struct + Column string + Expression string + type Border struct + Color string + Style int + Type string + type Cell struct + Formula string + StyleID int + Value interface{} + type CellType byte + const CellTypeBool + const CellTypeDate + const CellTypeError + const CellTypeFormula + const CellTypeInlineString + const CellTypeNumber + const CellTypeSharedString + const CellTypeUnset + type Chart struct + Border ChartLine + BubbleSize int + Dimension ChartDimension + Fill Fill + Format GraphicOptions + HoleSize int + Legend ChartLegend + PlotArea ChartPlotArea + Series []ChartSeries + ShowBlanksAs string + Title []RichTextRun + Type ChartType + 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 + NumFmt ChartNumFmt + ReverseOrder bool + Secondary bool + TickLabelPosition ChartTickLabelPositionType + TickLabelSkip int + Title []RichTextRun + type ChartDataLabelPositionType byte + const ChartDataLabelsPositionAbove + const ChartDataLabelsPositionBelow + const ChartDataLabelsPositionBestFit + const ChartDataLabelsPositionCenter + const ChartDataLabelsPositionInsideBase + const ChartDataLabelsPositionInsideEnd + const ChartDataLabelsPositionLeft + const ChartDataLabelsPositionOutsideEnd + const ChartDataLabelsPositionRight + const ChartDataLabelsPositionUnset + type ChartDimension struct + Height uint + Width uint + type ChartLegend struct + Position string + ShowLegendKey bool + type ChartLine struct + Smooth bool + Type ChartLineType + Width float64 + type ChartLineType byte + const ChartLineAutomatic + const ChartLineNone + const ChartLineSolid + type ChartMarker struct + Fill Fill + Size int + Symbol string + type ChartNumFmt struct + CustomNumFmt string + SourceLinked bool + type ChartPlotArea struct + Fill Fill + NumFmt ChartNumFmt + SecondPlotValues int + ShowBubbleSize bool + ShowCatName bool + ShowLeaderLines bool + ShowPercent bool + ShowSerName bool + ShowVal bool + type ChartSeries struct + Categories string + DataLabelPosition ChartDataLabelPositionType + Fill Fill + Line ChartLine + Marker ChartMarker + Name string + Sizes string + Values string + type ChartTickLabelPositionType byte + const ChartTickLabelHigh + const ChartTickLabelLow + const ChartTickLabelNextToAxis + const ChartTickLabelNone + type ChartType byte + 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 BarOfPie + 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 Contour + const Doughnut + const Line + const Line3D + const Pie + const Pie3D + const PieOfPie + const Radar + const Scatter + const Surface3D + const WireframeContour + const WireframeSurface3D + type ColorMappingType byte + type Cols struct + func (cols *Cols) Error() error + func (cols *Cols) Next() bool + func (cols *Cols) Rows(opts ...Options) ([]string, error) + type Comment struct + Author string + AuthorID int + Cell string + Height uint + Paragraph []RichTextRun + Text string + Width uint + type ConditionalFormatOptions struct + AboveAverage bool + BarBorderColor string + BarColor string + BarDirection string + BarOnly bool + BarSolid bool + Criteria string + Format *int + IconStyle string + IconsOnly bool + MaxColor string + MaxType string + MaxValue string + MidColor string + MidType string + MidValue string + MinColor string + MinType string + MinValue string + Percent bool + ReverseIcons bool + StopIfTrue bool + Type string + Value string + type CultureName byte + const CultureNameEnUS + const CultureNameUnknown + const CultureNameZhCN + 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 (dv *DataValidation) SetDropList(keys []string) error + func (dv *DataValidation) SetError(style DataValidationErrorStyle, title, msg string) + func (dv *DataValidation) SetInput(title, msg string) + func (dv *DataValidation) SetRange(f1, f2 interface{}, t DataValidationType, o DataValidationOperator) error + func (dv *DataValidation) SetSqref(sqref string) + func (dv *DataValidation) SetSqrefDropList(sqref string) + type DataValidationErrorStyle int + const DataValidationErrorStyleInformation + const DataValidationErrorStyleStop + const DataValidationErrorStyleWarning + type DataValidationOperator int + const DataValidationOperatorBetween + const DataValidationOperatorEqual + const DataValidationOperatorGreaterThan + const DataValidationOperatorGreaterThanOrEqual + const DataValidationOperatorLessThan + const DataValidationOperatorLessThanOrEqual + const DataValidationOperatorNotBetween + const DataValidationOperatorNotEqual + type DataValidationType int + const DataValidationTypeCustom + const DataValidationTypeDate + const DataValidationTypeDecimal + const DataValidationTypeList + const DataValidationTypeNone + const DataValidationTypeTextLength + const DataValidationTypeTime + const DataValidationTypeWhole + 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 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 + DecodeCellImages *decodeCellImages + 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 *decodeTheme + VMLDrawing map[string]*vmlDrawing + VolatileDeps *xlsxVolTypes + WorkBook *xlsxWorkbook + func NewFile(opts ...Options) *File + func OpenFile(filename string, opts ...Options) (*File, error) + func OpenReader(r io.Reader, opts ...Options) (*File, error) + func (f *File) AddChart(sheet, cell string, chart *Chart, combo ...*Chart) error + func (f *File) AddChartSheet(sheet string, chart *Chart, combo ...*Chart) error + func (f *File) AddComment(sheet string, opts Comment) error + func (f *File) AddDataValidation(sheet string, dv *DataValidation) error + func (f *File) AddFormControl(sheet string, opts FormControl) error + func (f *File) AddPicture(sheet, cell, name string, opts *GraphicOptions) error + func (f *File) AddPictureFromBytes(sheet, cell string, pic *Picture) error + func (f *File) AddPivotTable(opts *PivotTableOptions) error + func (f *File) AddShape(sheet string, opts *Shape) error + func (f *File) AddSlicer(sheet string, opts *SlicerOptions) error + func (f *File) AddSparkline(sheet string, opts *SparklineOptions) error + func (f *File) AddTable(sheet string, table *Table) error + func (f *File) AddVBAProject(file []byte) error + func (f *File) AutoFilter(sheet, rangeRef string, opts []AutoFilterOptions) error + func (f *File) CalcCellValue(sheet, cell string, opts ...Options) (result string, err error) + func (f *File) CharsetTranscoder(fn charsetTranscoderFn) *File + func (f *File) Close() error + func (f *File) Cols(sheet string) (*Cols, error) + func (f *File) CopySheet(from, to int) error + func (f *File) DeleteChart(sheet, cell string) error + func (f *File) DeleteComment(sheet, cell string) error + func (f *File) DeleteDataValidation(sheet string, sqref ...string) error + func (f *File) DeleteDefinedName(definedName *DefinedName) error + func (f *File) DeleteFormControl(sheet, cell string) error + func (f *File) DeletePicture(sheet, cell string) error + func (f *File) DeletePivotTable(sheet, name string) error + func (f *File) DeleteSheet(sheet string) error + func (f *File) DeleteTable(name string) error + 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) GetAppProps() (ret *AppProperties, err error) + func (f *File) GetBaseColor(hexColor string, indexedColor int, themeColor *int) string + func (f *File) GetCellFormula(sheet, cell string) (string, error) + func (f *File) GetCellHyperLink(sheet, cell string) (bool, string, error) + func (f *File) GetCellRichText(sheet, cell string) (runs []RichTextRun, err error) + func (f *File) GetCellStyle(sheet, cell string) (int, error) + func (f *File) GetCellType(sheet, cell string) (CellType, error) + func (f *File) GetCellValue(sheet, cell string, opts ...Options) (string, error) + func (f *File) GetColOutlineLevel(sheet, col string) (uint8, error) + func (f *File) GetColStyle(sheet, col string) (int, 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, opts ...Options) ([][]string, error) + func (f *File) GetComments(sheet string) ([]Comment, error) + func (f *File) GetConditionalFormats(sheet string) (map[string][]ConditionalFormatOptions, error) + func (f *File) GetConditionalStyle(idx int) (*Style, error) + func (f *File) GetDataValidations(sheet string) ([]*DataValidation, error) + func (f *File) GetDefaultFont() (string, error) + func (f *File) GetDefinedName() []DefinedName + func (f *File) GetDocProps() (ret *DocProperties, err error) + func (f *File) GetFormControls(sheet string) ([]FormControl, error) + func (f *File) GetHeaderFooter(sheet string) (*HeaderFooterOptions, error) + func (f *File) GetMergeCells(sheet string) ([]MergeCell, error) + func (f *File) GetPageLayout(sheet string) (PageLayoutOptions, error) + func (f *File) GetPageMargins(sheet string) (PageLayoutMarginsOptions, error) + func (f *File) GetPanes(sheet string) (Panes, error) + func (f *File) GetPictureCells(sheet string) ([]string, error) + func (f *File) GetPictures(sheet, cell string) ([]Picture, error) + func (f *File) GetPivotTables(sheet string) ([]PivotTableOptions, 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, opts ...Options) ([][]string, error) + func (f *File) GetSheetDimension(sheet string) (string, error) + func (f *File) GetSheetIndex(sheet string) (int, error) + func (f *File) GetSheetList() (list []string) + func (f *File) GetSheetMap() map[int]string + func (f *File) GetSheetName(index int) (name string) + func (f *File) GetSheetProps(sheet string) (SheetPropsOptions, error) + func (f *File) GetSheetView(sheet string, viewIndex int) (ViewOptions, error) + func (f *File) GetSheetVisible(sheet string) (bool, error) + func (f *File) GetStyle(idx int) (*Style, error) + func (f *File) GetTables(sheet string) ([]Table, error) + func (f *File) GetWorkbookProps() (WorkbookPropsOptions, error) + func (f *File) GroupSheets(sheets []string) error + func (f *File) InsertCols(sheet, col string, n int) error + func (f *File) InsertPageBreak(sheet, cell string) error + func (f *File) InsertRows(sheet string, row, n int) error + func (f *File) MergeCell(sheet, topLeftCell, bottomRightCell string) error + func (f *File) NewConditionalStyle(style *Style) (int, error) + func (f *File) NewSheet(sheet string) (int, error) + func (f *File) NewStreamWriter(sheet string) (*StreamWriter, error) + func (f *File) NewStyle(style *Style) (int, error) + func (f *File) ProtectSheet(sheet string, opts *SheetProtectionOptions) error + func (f *File) ProtectWorkbook(opts *WorkbookProtectionOptions) error + func (f *File) ReadZipReader(r *zip.Reader) (map[string][]byte, int, error) + func (f *File) RemoveCol(sheet, col string) error + func (f *File) RemovePageBreak(sheet, cell string) error + func (f *File) RemoveRow(sheet string, row int) error + func (f *File) Rows(sheet string) (*Rows, error) + func (f *File) Save(opts ...Options) error + func (f *File) SaveAs(name string, opts ...Options) error + func (f *File) SearchSheet(sheet, value string, reg ...bool) ([]string, error) + func (f *File) SetActiveSheet(index int) + func (f *File) SetAppProps(appProperties *AppProperties) error + func (f *File) SetCellBool(sheet, cell string, value bool) error + func (f *File) SetCellDefault(sheet, cell, value string) error + func (f *File) SetCellFloat(sheet, cell string, value float64, precision, bitSize int) error + func (f *File) SetCellFormula(sheet, cell, formula string, opts ...FormulaOpts) error + func (f *File) SetCellHyperLink(sheet, cell, link, linkType string, opts ...HyperlinkOpts) error + func (f *File) SetCellInt(sheet, cell string, value int) error + func (f *File) SetCellRichText(sheet, cell string, runs []RichTextRun) error + func (f *File) SetCellStr(sheet, cell, value string) error + func (f *File) SetCellStyle(sheet, topLeftCell, bottomRightCell string, styleID int) error + func (f *File) SetCellUint(sheet, cell string, value uint64) error + func (f *File) SetCellValue(sheet, cell 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, rangeRef string, opts []ConditionalFormatOptions) error + func (f *File) SetDefaultFont(fontName string) error + func (f *File) SetDefinedName(definedName *DefinedName) error + func (f *File) SetDocProps(docProperties *DocProperties) error + func (f *File) SetHeaderFooter(sheet string, opts *HeaderFooterOptions) error + func (f *File) SetPageLayout(sheet string, opts *PageLayoutOptions) error + func (f *File) SetPageMargins(sheet string, opts *PageLayoutMarginsOptions) error + func (f *File) SetPanes(sheet string, panes *Panes) 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) SetRowStyle(sheet string, start, end, styleID int) error + func (f *File) SetRowVisible(sheet string, row int, visible bool) error + func (f *File) SetSheetBackground(sheet, picture string) error + func (f *File) SetSheetBackgroundFromBytes(sheet, extension string, picture []byte) error + func (f *File) SetSheetCol(sheet, cell string, slice interface{}) error + func (f *File) SetSheetDimension(sheet string, rangeRef string) error + func (f *File) SetSheetName(source, target string) error + func (f *File) SetSheetProps(sheet string, opts *SheetPropsOptions) error + func (f *File) SetSheetRow(sheet, cell string, slice interface{}) error + func (f *File) SetSheetView(sheet string, viewIndex int, opts *ViewOptions) error + func (f *File) SetSheetVisible(sheet string, visible bool, veryHidden ...bool) error + func (f *File) SetWorkbookProps(opts *WorkbookPropsOptions) error + func (f *File) UngroupSheets() error + func (f *File) UnmergeCell(sheet, topLeftCell, bottomRightCell string) error + func (f *File) UnprotectSheet(sheet string, password ...string) error + func (f *File) UnprotectWorkbook(password ...string) error + func (f *File) UnsetConditionalFormat(sheet, rangeRef string) error + func (f *File) UpdateLinkedValue() error + func (f *File) Write(w io.Writer, opts ...Options) error + func (f *File) WriteTo(w io.Writer, opts ...Options) (int64, error) + func (f *File) WriteToBuffer() (*bytes.Buffer, error) + type Fill struct + Color []string + Pattern int + Shading int + Type string + type Font struct + Bold bool + Color string + ColorIndexed int + ColorTheme *int + ColorTint float64 + Family string + Italic bool + Size float64 + Strike bool + Underline string + VertAlign string + 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 FormulaOpts struct + Ref *string + Type *string + type GraphicOptions struct + AltText string + AutoFit bool + AutoFitIgnoreAspect bool + Hyperlink string + HyperlinkType string + LockAspectRatio bool + Locked *bool + OffsetX int + OffsetY int + Positioning string + PrintObject *bool + ScaleX float64 + ScaleY float64 + type HSL struct + H float64 + L float64 + S float64 + func (c HSL) RGBA() (uint32, uint32, uint32, uint32) + type HeaderFooterOptions struct + AlignWithMargins *bool + DifferentFirst bool + DifferentOddEven bool + EvenFooter string + EvenHeader string + FirstFooter string + FirstHeader string + OddFooter string + OddHeader string + ScaleWithDoc *bool + 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 + CultureInfo CultureName + LongDatePattern string + LongTimePattern string + MaxCalcIterations uint + Password string + RawCellValue bool + ShortDatePattern string + UnzipSizeLimit int64 + UnzipXMLSizeLimit int64 + 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 Panes struct + ActivePane string + Freeze bool + Selection []Selection + Split bool + TopLeftCell string + XSplit int + YSplit int + type Picture struct + Extension string + File []byte + Format *GraphicOptions + InsertType PictureInsertType + type PictureInsertType int + const PictureInsertTypeDISPIMG + const PictureInsertTypeIMAGE + const PictureInsertTypePlaceInCell + const PictureInsertTypePlaceOverCells + type PivotTableField struct + Compact bool + Data string + DefaultSubtotal bool + Name string + Outline bool + Subtotal string + type PivotTableOptions struct + ColGrandTotals bool + Columns []PivotTableField + CompactData bool + Data []PivotTableField + DataRange string + Filter []PivotTableField + MergeItem bool + Name string + 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 RichTextRun struct + Font *Font + Text string + type RowOpts struct + Height float64 + Hidden bool + OutlineLevel int + StyleID int + type Rows struct + func (rows *Rows) Close() error + func (rows *Rows) Columns(opts ...Options) ([]string, error) + func (rows *Rows) Error() error + func (rows *Rows) GetRowOpts() RowOpts + func (rows *Rows) Next() bool + type Selection struct + ActiveCell string + Pane string + SQRef string + type Shape struct + Cell string + Fill Fill + Format GraphicOptions + Height uint + Line ShapeLine + Macro string + Paragraph []RichTextRun + Type string + Width uint + type ShapeLine struct + Color string + Width *float64 + 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 SlicerOptions struct + Caption string + Cell string + DisplayHeader *bool + Format GraphicOptions + Height uint + ItemDesc bool + Macro string + Name string + TableName string + TableSheet string + Width uint + 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 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 + Sheet string + SheetID int + func (sw *StreamWriter) AddTable(table *Table) error + func (sw *StreamWriter) Flush() error + func (sw *StreamWriter) InsertPageBreak(cell string) error + func (sw *StreamWriter) MergeCell(topLeftCell, bottomRightCell string) error + func (sw *StreamWriter) SetColWidth(minVal, maxVal int, width float64) error + func (sw *StreamWriter) SetPanes(panes *Panes) error + func (sw *StreamWriter) SetRow(cell string, values []interface{}, opts ...RowOpts) error + type Style struct + Alignment *Alignment + Border []Border + CustomNumFmt *string + DecimalPlaces *int + Fill Fill + Font *Font + NegRed bool + NumFmt int + Protection *Protection + type Table struct + Name string + Range string + ShowColumnStripes bool + ShowFirstColumn bool + ShowHeaderRow *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 Other modules containing this package github.com/gembahub/excelize
Go to main page