Versions in this module Expand all Collapse all v3 v3.2.6 Dec 28, 2021 Changes in this version type SheetView + ZoomScale float64 v3.2.5 Dec 28, 2021 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 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 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) 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 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) 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 Other modules containing this package github.com/shangsharon/xlsx
Go to main page