xlsx

package module

Go to main page

Versions in this module

v1

v1.0.11

Jan 26, 2024

v1.0.10

Jan 26, 2024

v1.0.9

Jan 25, 2024

Changes in this version

type Row

+ func (r *Row) GetCellStoreRow() CellStoreRow

v1.0.8

Jan 25, 2024

Changes in this version

type CellStore

+ HandleRow func(r *Row, f *File) error

type DiskVCellStore

+ func (cs *DiskVCellStore) HandleRow(r *Row, f *File) error

type MemoryCellStore

+ func (mcs *MemoryCellStore) HandleRow(r *Row, f *File) error

v1.0.7

Jan 25, 2024

v1.0.6

Jan 24, 2024

v1.0.5

Jan 24, 2024

Changes in this version

type FileOption

+ func SetCellStoreConstructorArgs(args ...any) FileOption

v1.0.4

Jan 24, 2024

Changes in this version

type FileOption

+ func SetCellStoreArgs(args ...any) FileOption

v1.0.3

Jan 24, 2024

v1.0.2

Jan 24, 2024

v1.0.1

Jan 24, 2024

v1.0.0

Jan 24, 2024

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 NoColLimit

+ 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(n int) string

+ func ColLettersToIndex(letters string) int

+ func DefaultAutoWidth(s string) float64

+ 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 IsSaneSheetName(sheetName string) error

+ 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) GetCoordinates() (int, int)

+ 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) Modified() bool

+ 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

+ MakeRow func(sheet *Sheet) *Row

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

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

+ ReadRow func(key string, sheet *Sheet) (*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 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 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 DefinedName xlsxDefinedName

+ type DiskVCellStore struct

+ func (cs *DiskVCellStore) Close() error

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

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

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

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

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

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

+ 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 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) AddDefinedName(name DefinedName) 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 ColLimit(n int) FileOption

+ func RowLimit(n int) FileOption

+ func SetCellStoreConstructor(constructor CellStoreConstructor) FileOption

+ func ValueOnly() 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

+ Strike bool

+ 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

+ Location string

+ Tooltip string

+ type MemoryCellStore struct

+ func (mcs *MemoryCellStore) Close() error

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

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

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

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

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

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

+ 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 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) GetCoordinate() int

+ func (r *Row) GetHeight() float64

+ func (r *Row) GetOutlineLevel() uint8

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

+ 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) GetCellStore() CellStore

+ 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) SetColAutoWidth(colIndex int, width func(string) float64) 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

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