Versions in this module Expand all Collapse all v2 v2.4.1 May 17, 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 ErrColumnNumber = errors.New("column number exceeds maximum limit") + var ErrColumnWidth = errors.New("the width of the column must be smaller than or equal to 255 characters") + var ErrCoordinates = errors.New("coordinates length must be 4") + var ErrExistsWorksheet = errors.New("the same name worksheet already exists") + 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 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 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 map[string]*xlsxWsDr + Path string + Relationships map[string]*xlsxRelationships + SharedStrings *xlsxSST + Sheet map[string]*xlsxWorksheet + SheetCount int + Styles *xlsxStyleSheet + Theme *xlsxTheme + VMLDrawing map[string]*vmlDrawing + WorkBook *xlsxWorkbook + XLSX map[string][]byte + 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 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{}) 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 v2.4.0-fix2 May 17, 2021 v2.4.0-fix May 17, 2021 Other modules containing this package github.com/IsotronicGmbH/excelize
Go to main page