Versions in this module Expand all Collapse all v2 v2.3.7 May 18, 2021 v2.3.6 May 18, 2021 v2.3.5 May 18, 2021 v2.3.4 May 18, 2021 v2.3.3 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 FileNameLength + const Line + const NameSpaceDrawingML + const NameSpaceDrawingMLChart + const NameSpaceDrawingMLSpreadSheet + const NameSpaceDublinCore + const NameSpaceDublinCoreMetadataIntiative + const NameSpaceDublinCoreTerms + const NameSpaceMacExcel2008Main + const NameSpaceSpreadSheetExcel2006Main + const NameSpaceSpreadSheetX15 + 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 SourceRelationshipChart20070802 + const SourceRelationshipChart2014 + const SourceRelationshipChart201506 + const SourceRelationshipChartsheet + const SourceRelationshipComments + const SourceRelationshipDialogsheet + const SourceRelationshipDrawingML + const SourceRelationshipDrawingVML + const SourceRelationshipHyperLink + const SourceRelationshipImage + const SourceRelationshipPivotCache + const SourceRelationshipPivotTable + const SourceRelationshipSharedStrings + const SourceRelationshipTable + const SourceRelationshipVBAProject + const SourceRelationshipWorkSheet + const StrictNameSpaceSpreadSheet + const StrictSourceRelationship + const StrictSourceRelationshipChart + const StrictSourceRelationshipComments + const StrictSourceRelationshipImage + const Surface3D + const TotalCellChars + const TotalColumns + const TotalRows + const TotalSheetHyperlinks + const WireframeContour + const WireframeSurface3D + const XMLHeader + var HSLModel = color.ModelFunc(hslModel) + var NameSpaceSpreadSheet = xml.Attr + var NameSpaceSpreadSheetX14 = xml.Attr + var SourceRelationship = 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) (string, 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 ArgMatrix + const ArgString + const ArgUnknown + type AutoPageBreaks bool + type BaseColWidth uint8 + type Border struct + Color string + Style int + Type string + type Cell struct + 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 DataValidation struct + AllowBlank bool + Error *string + ErrorStyle *string + ErrorTitle *string + Formula1 string + Formula2 string + Operator string + Prompt *string + PromptTitle *string + ShowDropDown bool + ShowErrorMessage bool + ShowInputMessage bool + Sqref string + Type string + func NewDataValidation(allowBlank bool) *DataValidation + func (dd *DataValidation) SetDropList(keys []string) error + func (dd *DataValidation) SetError(style DataValidationErrorStyle, title, msg string) + func (dd *DataValidation) SetInput(title, msg string) + func (dd *DataValidation) SetRange(f1, f2 int, t DataValidationType, o DataValidationOperator) error + func (dd *DataValidation) SetSqref(sqref string) + func (dd *DataValidation) SetSqrefDropList(sqref string, isCurrentSheet bool) error + type DataValidationErrorStyle int + const DataValidationErrorStyleInformation + const DataValidationErrorStyleStop + const DataValidationErrorStyleWarning + type DataValidationOperator int + type DataValidationType int + type 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 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) (*File, error) + func OpenReader(r io.Reader) (*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) 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) 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) 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 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 MergeCell []string + func (m *MergeCell) GetCellValue() string + func (m *MergeCell) GetEndAxis() string + func (m *MergeCell) GetStartAxis() string + type OutlineSummaryBelow bool + type PageLayoutOption interface + type PageLayoutOptionPtr interface + type PageLayoutOrientation string + type PageLayoutPaperSize int + type 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 + Name string + Subtotal string + type PivotTableOption struct + Columns []PivotTableField + Data []PivotTableField + DataRange string + Filter []PivotTableField + PivotTableRange string + Rows []PivotTableField + 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 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) 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 ThickBottom bool + type ThickTop bool + type TopLeftCell string + type ZeroHeight bool + type ZoomScale float64 Other modules containing this package github.com/DynexIT/excelize