xlsx

package module

Go to main page

Versions in this module

v3

v3.3.6

Apr 4, 2024

v3.3.5

Jan 3, 2024

v3.3.4

Oct 24, 2023

v3.3.3

Oct 24, 2023

Changes in this version

+ func IsSaneSheetName(sheetName string) error

v3.3.2

Sep 18, 2023

v3.3.1

Sep 13, 2023

v3.3.0

May 23, 2023

Changes in this version

+ type DefinedName xlsxDefinedName

type File

+ func (f *File) AddDefinedName(name DefinedName) error

v3.2.4

Dec 13, 2021

Changes in this version

+ const NoColLimit

type FileOption

+ func ColLimit(n int) FileOption

+ func ValueOnly() FileOption

v3.2.3

Nov 16, 2020

v3.2.2

Nov 14, 2020

v3.2.1

Oct 19, 2020

Changes in this version

+ func DefaultAutoWidth(s string) float64

type Cell

+ func (c *Cell) Modified() bool

type CellStore

+ MakeRow func(sheet *Sheet) *Row

+ MakeRowWithLen func(sheet *Sheet, len int) *Row

+ type CellStoreRow interface

+ AddCell func() *Cell

+ CellCount func() int

+ CellUpdatable func(c *Cell)

+ ForEachCell func(cvf CellVisitorFunc, option ...CellVisitorOption) error

+ GetCell func(colIdx int) *Cell

+ MaxCol func() int

+ PushCell func(c *Cell)

+ Updatable func()

type DiskVCellStore

+ func (cs *DiskVCellStore) MakeRow(sheet *Sheet) *Row

+ func (cs *DiskVCellStore) MakeRowWithLen(sheet *Sheet, len int) *Row

+ type DiskVRow struct

+ func (dvr *DiskVRow) AddCell() *Cell

+ func (dvr *DiskVRow) CellCount() int

+ func (dvr *DiskVRow) CellUpdatable(c *Cell)

+ func (dvr *DiskVRow) ForEachCell(cvf CellVisitorFunc, option ...CellVisitorOption) error

+ func (dvr *DiskVRow) GetCell(colIdx int) *Cell

+ func (dvr *DiskVRow) MaxCol() int

+ func (dvr *DiskVRow) PushCell(c *Cell)

+ func (dvr *DiskVRow) Updatable()

type Hyperlink

+ Location string

type MemoryCellStore

+ func (mcs *MemoryCellStore) MakeRow(sheet *Sheet) *Row

+ func (mcs *MemoryCellStore) MakeRowWithLen(sheet *Sheet, len int) *Row

+ type MemoryRow struct

+ func (mr *MemoryRow) AddCell() *Cell

+ func (mr *MemoryRow) CellCount() int

+ func (mr *MemoryRow) CellUpdatable(c *Cell)

+ func (mr *MemoryRow) ForEachCell(cvf CellVisitorFunc, option ...CellVisitorOption) error

+ func (mr *MemoryRow) GetCell(colIdx int) *Cell

+ func (mr *MemoryRow) MaxCol() int

+ func (mr *MemoryRow) PushCell(c *Cell)

+ func (mr *MemoryRow) Updatable()

type Row

+ func (r *Row) PushCell(c *Cell)

type Sheet

+ func (s *Sheet) SetColAutoWidth(colIndex int, width func(string) float64) error

v3.2.0

Jun 20, 2020

Changes in this version

type Cell

+ func (c *Cell) GetCoordinates() (int, int)

type Row

+ func (r *Row) GetCoordinate() int

v3.1.1

Jun 9, 2020

v3.1.0

Jun 6, 2020

Changes in this version

type Font

+ Strike bool

v3.0.0

Apr 27, 2020

Changes in this version

+ const Baskerville

+ const Bodoni

+ const ColWidth

+ const Courier

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

+ const Excel2006MaxRowIndex

+ const FALSE

+ const GS

+ const GillSans

+ const Helvetica

+ const MJD_0

+ const MJD_JD2000

+ const NoRowLimit

+ const RGB_Black

+ const RGB_Dark_Green

+ const RGB_Dark_Red

+ const RGB_Light_Green

+ const RGB_Light_Red

+ const RGB_White

+ const RS

+ const RichTextCharsetANSI

+ const RichTextCharsetArabic

+ const RichTextCharsetBIG5

+ const RichTextCharsetBaltic

+ const RichTextCharsetDefault

+ const RichTextCharsetEastEurope

+ const RichTextCharsetGB2312

+ const RichTextCharsetGreek

+ const RichTextCharsetHangul

+ const RichTextCharsetHebrew

+ const RichTextCharsetJohab

+ const RichTextCharsetMac

+ const RichTextCharsetOEM

+ const RichTextCharsetRussian

+ const RichTextCharsetShiftJIS

+ const RichTextCharsetSymbol

+ const RichTextCharsetThai

+ const RichTextCharsetTurkish

+ const RichTextCharsetUnspecified

+ const RichTextCharsetVietnamese

+ const RichTextFontFamilyDecorative

+ const RichTextFontFamilyModern

+ const RichTextFontFamilyNotApplicable

+ const RichTextFontFamilyRoman

+ const RichTextFontFamilyScript

+ const RichTextFontFamilySwiss

+ const RichTextFontFamilyUnspecified

+ const RichTextUnderlineDouble

+ const RichTextUnderlineSingle

+ const RichTextVertAlignSubscript

+ const RichTextVertAlignSuperscript

+ const Solid_Cell_Fill

+ const TEMPLATE_DOCPROPS_APP

+ const TEMPLATE_DOCPROPS_CORE

+ const TEMPLATE_XL_THEME_THEME

+ const TEMPLATE__RELS_DOT_RELS

+ const TRUE

+ const TimesNewRoman

+ const US

+ var DefaultDateFormat = builtInNumFmt[14]

+ var DefaultDateOptions = DateTimeOptions

+ var DefaultDateTimeFormat = builtInNumFmt[22]

+ var DefaultDateTimeOptions = DateTimeOptions

+ var HSLModel = color.ModelFunc(hslModel)

+ func ColIndexToLetters(colRef int) string

+ func ColLettersToIndex(letters string) int

+ func FileToSlice(path string, options ...FileOption) ([][][]string, error)

+ func FileToSliceUnmerged(path string, options ...FileOption) ([][][]string, error)

+ func GetCellIDStringFromCoords(x, y int) string

+ func GetCellIDStringFromCoordsWithFixed(x, y int, xFixed, yFixed bool) string

+ func GetCoordsFromCellIDString(cellIDString string) (x, y int, err error)

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

+ func MakeDefaultContentTypes() (types xlsxTypes)

+ func NewDataValidation(startRow, startCol, endRow, endCol int, allowBlank bool) *xlsxDataValidation

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

+ func RowIndexToString(rowRef int) string

+ func SetDefaultFont(size float64, name string)

+ func SkipEmptyCells(flags *cellVisitorFlags)

+ func SkipEmptyRows(flags *rowVisitorFlags)

+ func TimeFromExcelTime(excelTime float64, date1904 bool) time.Time

+ func TimeToExcelTime(t time.Time, date1904 bool) float64

+ func TimeToUTCTime(t time.Time) time.Time

+ func UseDiskVCellStore(f *File)

+ func UseMemoryCellStore(f *File)

+ type Alignment struct

+ Horizontal string

+ Indent int

+ ShrinkToFit bool

+ TextRotation int

+ Vertical string

+ WrapText bool

+ func DefaultAlignment() *Alignment

+ type AutoFilter struct

+ BottomRightCell string

+ TopLeftCell string

+ type Border struct

+ Bottom string

+ BottomColor string

+ Left string

+ LeftColor string

+ Right string

+ RightColor string

+ Top string

+ TopColor string

+ func DefaultBorder() *Border

+ func NewBorder(left, right, top, bottom string) *Border

+ type Cell struct

+ DataValidation *xlsxDataValidation

+ HMerge int

+ Hidden bool

+ Hyperlink Hyperlink

+ NumFmt string

+ RichText []RichTextRun

+ Row *Row

+ VMerge int

+ Value string

+ func (c *Cell) Bool() bool

+ func (c *Cell) Float() (float64, error)

+ func (c *Cell) FormattedValue() (string, error)

+ func (c *Cell) Formula() string

+ func (c *Cell) GeneralNumeric() (string, error)

+ func (c *Cell) GeneralNumericWithoutScientific() (string, error)

+ func (c *Cell) GetNumberFormat() string

+ func (c *Cell) GetStyle() *Style

+ func (c *Cell) GetTime(date1904 bool) (t time.Time, err error)

+ func (c *Cell) Int() (int, error)

+ func (c *Cell) Int64() (int64, error)

+ func (c *Cell) IsTime() bool

+ func (c *Cell) Merge(hcells, vcells int)

+ func (c *Cell) SetBool(b bool)

+ func (c *Cell) SetDataValidation(dd *xlsxDataValidation)

+ func (c *Cell) SetDate(t time.Time)

+ func (c *Cell) SetDateTime(t time.Time)

+ func (c *Cell) SetDateTimeWithFormat(n float64, format string)

+ func (c *Cell) SetDateWithOptions(t time.Time, options DateTimeOptions)

+ func (c *Cell) SetFloat(n float64)

+ func (c *Cell) SetFloatWithFormat(n float64, format string)

+ func (c *Cell) SetFormat(format string)

+ func (c *Cell) SetFormula(formula string)

+ func (c *Cell) SetHyperlink(hyperlink string, displayText string, tooltip string)

+ func (c *Cell) SetInt(n int)

+ func (c *Cell) SetInt64(n int64)

+ func (c *Cell) SetNumeric(s string)

+ func (c *Cell) SetRichText(r []RichTextRun)

+ func (c *Cell) SetString(s string)

+ func (c *Cell) SetStringFormula(formula string)

+ func (c *Cell) SetStyle(style *Style)

+ func (c *Cell) SetValue(n interface{})

+ func (c *Cell) String() string

+ func (c *Cell) Type() CellType

+ func (c *Cell) UnmarshalBinary(data []byte) error

+ func (c Cell) MarshalBinary() ([]byte, error)

+ type CellInterface interface

+ FormattedValue func() string

+ String func() string

+ type CellStore interface

+ Close func() error

+ MoveRow func(r *Row, newIndex int) error

+ ReadRow func(key string) (*Row, error)

+ RemoveRow func(key string) error

+ WriteRow func(r *Row) error

+ func NewDiskVCellStore() (CellStore, error)

+ func NewMemoryCellStore() (CellStore, error)

+ type CellStoreConstructor func() (CellStore, error)

+ type CellType int

+ const CellTypeBool

+ const CellTypeDate

+ const CellTypeError

+ const CellTypeInline

+ const CellTypeNumeric

+ const CellTypeString

+ const CellTypeStringFormula

+ func (ct CellType) Ptr() *CellType

+ type CellVisitorFunc func(c *Cell) error

+ type CellVisitorOption func(flags *cellVisitorFlags)

+ type Col struct

+ BestFit *bool

+ Collapsed *bool

+ CustomWidth *bool

+ Hidden *bool

+ Max int

+ Min int

+ OutlineLevel *uint8

+ Phonetic *bool

+ Width *float64

+ func NewColForRange(min, max int) *Col

+ func (c *Col) GetStyle() *Style

+ func (c *Col) SetOutlineLevel(outlineLevel uint8)

+ func (c *Col) SetStyle(style *Style)

+ func (c *Col) SetType(cellType CellType)

+ func (c *Col) SetWidth(width float64)

+ type ColStore struct

+ Len int

+ Root *ColStoreNode

+ func (cs *ColStore) Add(col *Col) *ColStoreNode

+ func (cs *ColStore) FindColByIndex(index int) *Col

+ func (cs *ColStore) ForEach(fn func(idx int, col *Col))

+ type ColStoreNode struct

+ Col *Col

+ Next *ColStoreNode

+ Prev *ColStoreNode

+ type DataValidationErrorStyle int

+ const StyleInformation

+ const StyleStop

+ const StyleWarning

+ type DataValidationOperator int

+ type DataValidationType int

+ type DateTimeOptions struct

+ ExcelTimeFormat string

+ Location *time.Location

+ type DiskVCellStore struct

+ func (cs *DiskVCellStore) Close() error

+ func (cs *DiskVCellStore) MoveRow(r *Row, index int) error

+ func (cs *DiskVCellStore) ReadRow(key string) (*Row, error)

+ func (cs *DiskVCellStore) RemoveRow(key string) error

+ func (cs *DiskVCellStore) WriteRow(r *Row) error

+ type File struct

+ Date1904 bool

+ DefinedNames []*xlsxDefinedName

+ Sheet map[string]*Sheet

+ Sheets []*Sheet

+ func NewFile(options ...FileOption) *File

+ func OpenBinary(bs []byte, options ...FileOption) (*File, error)

+ func OpenFile(fileName string, options ...FileOption) (file *File, err error)

+ func OpenReaderAt(r io.ReaderAt, size int64, options ...FileOption) (*File, error)

+ func ReadZip(f *zip.ReadCloser, options ...FileOption) (*File, error)

+ func ReadZipReader(r *zip.Reader, options ...FileOption) (*File, error)

+ func (f *File) AddSheet(sheetName string) (*Sheet, error)

+ func (f *File) AddSheetWithCellStore(sheetName string, constructor CellStoreConstructor) (*Sheet, error)

+ func (f *File) AppendSheet(sheet Sheet, sheetName string) (*Sheet, error)

+ func (f *File) MakeStreamParts() (map[string]string, error)

+ func (f *File) MarshallParts(zipWriter *zip.Writer) error

+ func (f *File) Save(path string) (err error)

+ func (f *File) ToSlice() (output [][][]string, err error)

+ func (f *File) ToSliceUnmerged() (output [][][]string, err error)

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

+ type FileOption func(f *File)

+ func RowLimit(n int) FileOption

+ type Fill struct

+ BgColor string

+ FgColor string

+ PatternType string

+ func DefaultFill() *Fill

+ func NewFill(patternType, fgColor, bgColor string) *Fill

+ type Font struct

+ Bold bool

+ Charset int

+ Color string

+ Family int

+ Italic bool

+ Name string

+ Size float64

+ Underline bool

+ func DefaultFont() *Font

+ func NewFont(size float64, name string) *Font

+ type HSL struct

+ H float64

+ L float64

+ S float64

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

+ type Hyperlink struct

+ DisplayString string

+ Link string

+ Tooltip string

+ type MemoryCellStore struct

+ func (mcs *MemoryCellStore) Close() error

+ func (mcs *MemoryCellStore) MoveRow(r *Row, index int) error

+ func (mcs *MemoryCellStore) ReadRow(key string) (*Row, error)

+ func (mcs *MemoryCellStore) RemoveRow(key string) error

+ func (mcs *MemoryCellStore) WriteRow(r *Row) error

+ type Pane struct

+ ActivePane string

+ State string

+ TopLeftCell string

+ XSplit float64

+ YSplit float64

+ type RefTable struct

+ func MakeSharedStringRefTable(source *xlsxSST) *RefTable

+ func NewSharedStringRefTable() *RefTable

+ func (rt *RefTable) AddRichText(r []RichTextRun) int

+ func (rt *RefTable) AddString(str string) int

+ func (rt *RefTable) Length() int

+ func (rt *RefTable) ResolveSharedString(index int) (plainText string, richText []RichTextRun)

+ type Relation struct

+ Target string

+ TargetMode RelationshipTargetMode

+ Type RelationshipType

+ type RelationshipTargetMode string

+ const RelationshipTargetModeExternal

+ type RelationshipType string

+ const RelationshipTypeHyperlink

+ type RichTextCharset int

+ type RichTextColor struct

+ func NewRichTextColorFromARGB(alpha, red, green, blue int) *RichTextColor

+ func NewRichTextColorFromThemeColor(themeColor int) *RichTextColor

+ type RichTextFont struct

+ Bold bool

+ Charset RichTextCharset

+ Color *RichTextColor

+ Family RichTextFontFamily

+ Italic bool

+ Name string

+ Size float64

+ Strike bool

+ Underline RichTextUnderline

+ VertAlign RichTextVertAlign

+ type RichTextFontFamily int

+ type RichTextRun struct

+ Font *RichTextFont

+ Text string

+ func (rt *RichTextRun) Equals(other *RichTextRun) bool

+ type RichTextUnderline string

+ type RichTextVertAlign string

+ type Row struct

+ Hidden bool

+ Sheet *Sheet

+ func (r *Row) AddCell() *Cell

+ func (r *Row) ForEachCell(cvf CellVisitorFunc, option ...CellVisitorOption) error

+ func (r *Row) GetCell(colIdx int) *Cell

+ func (r *Row) GetHeight() float64

+ func (r *Row) GetOutlineLevel() uint8

+ func (r *Row) ReadStruct(ptr interface{}) error

+ func (r *Row) SetHeight(ht float64)

+ func (r *Row) SetHeightCM(ht float64)

+ func (r *Row) SetOutlineLevel(outlineLevel uint8)

+ func (r *Row) WriteSlice(e interface{}, cols int) int

+ func (r *Row) WriteStruct(e interface{}, cols int) int

+ type RowNotFoundError struct

+ func NewRowNotFoundError(key, reason string) *RowNotFoundError

+ func (cnfe RowNotFoundError) Error() string

+ type RowVisitor func(r *Row) error

+ type RowVisitorOption func(flags *rowVisitorFlags)

+ type Sheet struct

+ AutoFilter *AutoFilter

+ Cols *ColStore

+ DataValidations []*xlsxDataValidation

+ File *File

+ Hidden bool

+ MaxCol int

+ MaxRow int

+ Name string

+ Relations []Relation

+ Selected bool

+ SheetFormat SheetFormat

+ SheetViews []SheetView

+ func NewSheet(name string) (*Sheet, error)

+ func NewSheetWithCellStore(name string, constructor CellStoreConstructor) (*Sheet, error)

+ func (s *Sheet) AddDataValidation(dv *xlsxDataValidation)

+ func (s *Sheet) AddRow() *Row

+ func (s *Sheet) AddRowAtIndex(index int) (*Row, error)

+ func (s *Sheet) Cell(row, col int) (*Cell, error)

+ func (s *Sheet) Close()

+ func (s *Sheet) Col(idx int) *Col

+ func (s *Sheet) ForEachRow(rv RowVisitor, options ...RowVisitorOption) error

+ func (s *Sheet) MarshalSheet(w io.Writer, refTable *RefTable, styles *xlsxStyleSheet, ...) error

+ func (s *Sheet) RemoveRowAtIndex(index int) error

+ func (s *Sheet) Row(idx int) (*Row, error)

+ func (s *Sheet) SetColParameters(col *Col)

+ func (s *Sheet) SetColWidth(min, max int, width float64)

+ func (s *Sheet) SetOutlineLevel(minCol, maxCol int, outlineLevel uint8)

+ func (s *Sheet) SetType(minCol, maxCol int, cellType CellType)

+ type SheetFormat struct

+ DefaultColWidth float64

+ DefaultRowHeight float64

+ OutlineLevelCol uint8

+ OutlineLevelRow uint8

+ type SheetView struct

+ Pane *Pane

+ type Style struct

+ Alignment Alignment

+ ApplyAlignment bool

+ ApplyBorder bool

+ ApplyFill bool

+ ApplyFont bool

+ Border Border

+ Fill Fill

+ Font Font

+ NamedStyleIndex *int

+ func NewStyle() *Style

+ type WorkBookRels map[string]string

+ func (w *WorkBookRels) MakeXLSXWorkbookRels() xlsxWorkbookRels

+ type XLSXReaderError struct

+ Err string

+ func (e *XLSXReaderError) Error() string

+ type XLSXUnmarshaler interface

+ Unmarshal func(*Row) error

Other modules containing this package

github.com/tealeg/xlsx

github.com/tealeg/xlsx/v2

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