Versions in this module Expand all Collapse all v1 v1.0.6 Mar 27, 2023 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 DateFormat_dd_mm_yy + const DateTimeFormat_d_m_yy_h_mm + const DecimalFormat + const Excel2006MaxRowCount + const Excel2006MaxRowIndex + const FALSE + const GS + const GeneralFormat + const GillSans + const Helvetica + const IntegerFormat + 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 AlreadyOnLastSheetError = errors.New("NextSheet() called, but already on last sheet") + var BuiltStreamFileBuilderError = errors.New("StreamFileBuilder has already been built, functions may no longer be used") + var DefaultDateFormat = builtInNumFmt[14] + var DefaultDateOptions = DateTimeOptions + var DefaultDateTimeFormat = builtInNumFmt[22] + var DefaultDateTimeOptions = DateTimeOptions + var HSLModel = color.ModelFunc(hslModel) + var NoCurrentSheetError = errors.New("no Current Sheet") + var UnsupportedCellTypeError = errors.New("the given cell type is not supported") + var WrongNumberOfRowsError = errors.New(...) + 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, error 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 int, name string) + 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 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) MarshallParts() (map[string]string, 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) (err error) + type FileOption func(f *File) + func RowLimit(n int) FileOption + type Fill struct + BgColor string + FgColor string + PatternType string + var FillGreen *Fill + var FillRed *Fill + var FillWhite *Fill + 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 int + Underline bool + var FontBold *Font + var FontItalic *Font + var FontUnderlined *Font + func DefaultFont() *Font + func NewFont(size int, 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 + Height float64 + Hidden bool + OutlineLevel uint8 + Sheet *Sheet + func (r *Row) AddCell() *Cell + func (r *Row) ForEachCell(cvf CellVisitorFunc) error + func (r *Row) GetCell(colIdx int) *Cell + func (r *Row) ReadStruct(ptr interface{}) error + func (r *Row) SetHeight(ht float64) + func (r *Row) SetHeightCM(ht float64) + 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 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) 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 StreamCell struct + func NewDateStreamCell(t time.Time) StreamCell + func NewIntegerStreamCell(cellData int) StreamCell + func NewStreamCell(cellData string, cellStyle StreamStyle, cellType CellType) StreamCell + func NewStringStreamCell(cellData string) StreamCell + func NewStyledIntegerStreamCell(cellData int, cellStyle StreamStyle) StreamCell + func NewStyledStringStreamCell(cellData string, cellStyle StreamStyle) StreamCell + type StreamFile struct + func (sf *StreamFile) AddMergeCells(startRowIdx, startColumnIdx, endRowIdx, endColumnIdx int) + func (sf *StreamFile) Close() error + func (sf *StreamFile) Error() error + func (sf *StreamFile) Flush() + func (sf *StreamFile) NextSheet() error + func (sf *StreamFile) Write(cells []string) error + func (sf *StreamFile) WriteAll(records [][]string) error + func (sf *StreamFile) WriteAllS(records [][]StreamCell) error + func (sf *StreamFile) WriteS(cells []StreamCell) error + func (sf *StreamFile) WriteWithColumnDefaultMetadata(cells []string) error + type StreamFileBuilder struct + func NewStreamFileBuilder(writer io.Writer, options ...FileOption) *StreamFileBuilder + func NewStreamFileBuilderForPath(path string, options ...FileOption) (*StreamFileBuilder, error) + func (sb *StreamFileBuilder) AddNewNumberFormat(formatCode string) int + func (sb *StreamFileBuilder) AddSheet(name string, cellTypes []*CellType) error + func (sb *StreamFileBuilder) AddSheetS(name string, columnStyles []StreamStyle) error + func (sb *StreamFileBuilder) AddSheetWithAutoFilters(name string, cellTypes []*CellType) error + func (sb *StreamFileBuilder) AddSheetWithDefaultColumnMetadata(name string, columnsDefaultStreamingCellMetadata []*StreamingCellMetadata) error + func (sb *StreamFileBuilder) AddStreamStyle(streamStyle StreamStyle) error + func (sb *StreamFileBuilder) AddStreamStyleList(streamStyles []StreamStyle) error + func (sb *StreamFileBuilder) AddValidation(sheetIndex int, validation *xlsxDataValidation) + func (sb *StreamFileBuilder) Build() (*StreamFile, error) + type StreamStyle struct + var StreamStyleBoldInteger StreamStyle + var StreamStyleBoldString StreamStyle + var StreamStyleDefaultDate StreamStyle + var StreamStyleDefaultDecimal StreamStyle + var StreamStyleDefaultInteger StreamStyle + var StreamStyleDefaultString StreamStyle + var StreamStyleFromColumn StreamStyle + var StreamStyleItalicInteger StreamStyle + var StreamStyleItalicString StreamStyle + var StreamStyleUnderlinedInteger StreamStyle + var StreamStyleUnderlinedString StreamStyle + func MakeDateStyle(font *Font, fill *Fill, alignment *Alignment, border *Border) StreamStyle + func MakeDecimalStyle(font *Font, fill *Fill, alignment *Alignment, border *Border) StreamStyle + func MakeIntegerStyle(font *Font, fill *Fill, alignment *Alignment, border *Border) StreamStyle + func MakeStringStyle(font *Font, fill *Fill, alignment *Alignment, border *Border) StreamStyle + func MakeStyle(numFormatId int, font *Font, fill *Fill, alignment *Alignment, border *Border) StreamStyle + type StreamingCellMetadata struct + var DefaultDateStreamingCellMetadata StreamingCellMetadata + var DefaultDecimalStreamingCellMetadata StreamingCellMetadata + var DefaultIntegerStreamingCellMetadata StreamingCellMetadata + var DefaultNumericStreamingCellMetadata StreamingCellMetadata + var DefaultStringStreamingCellMetadata StreamingCellMetadata + func MakeStreamingCellMetadata(cellType CellType, streamStyle StreamStyle) StreamingCellMetadata + func (cm StreamingCellMetadata) Ptr() *StreamingCellMetadata + 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 v1.0.3 Jul 14, 2017 v1.0.2 Jul 14, 2017 v1.0.1 Jul 14, 2017 v1.0.0 May 5, 2017
Go to main page