exl

Nov 23, 2023

Changes in this version

+ var DefaultUnmarshalFuncs = map[reflect.Kind]UnmarshalExcelFunc

+ var ErrCannotCastUnmarshaler = errors.New("cannot cast to unmarshaler interface")

+ var ErrNegativeUInt = errors.New("negative integer provided for unsigned field")

+ var ErrNoDestinationField = errors.New("no destination field with matching tag")

+ var ErrNoRecognizedFormat = errors.New("no recognized format")

+ var ErrNoUnmarshaler = errors.New("no unmarshaler")

+ var ErrOverflow = errors.New("numeric overflow, number is too large for this field")

+ func UnmarshalBool(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalExcelUnmarshaler(destField reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalFloat(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalInt(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalString(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalTextUnmarshaler(destField reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalTime(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func UnmarshalUInt(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ type ContentError struct

+ FieldErrors []FieldError

+ LimitReached bool

+ func (e ContentError) Error() string

+ func (e ContentError) Unwrap() []error

+ type ExcelUnmarshalParameters struct

+ Date1904 bool

+ FallbackDateFormats []string

+ TrimSpace bool

+ type ExcelUnmarshaler interface

+ UnmarshalExcel func(cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ type FieldError struct

+ ColumnHeader string

+ ColumnIndex int

+ Err error

+ RowIndex int

+ func (e FieldError) Error() string

+ func (e FieldError) Unwrap() error

type ReadConfig

+ FallbackDateFormats []string

+ MaxUnmarshalErrors uint64

+ SkipUnknownColumns bool

+ SkipUnknownTypes bool

+ UnmarshalErrorHandling UnmarshalErrorHandling

+ type UnmarshalErrorHandling uint8

+ const UnmarshalErrorAbort

+ const UnmarshalErrorCollect

+ const UnmarshalErrorIgnore

+ type UnmarshalExcelFunc func(destValue reflect.Value, cell *xlsx.Cell, params *ExcelUnmarshalParameters) error

+ func GetUnmarshalFunc(destField reflect.Value) UnmarshalExcelFunc

Aug 4, 2023

Changes in this version

type ReadConfigurator

+ ReadConfigure func(rc *ReadConfig)

type WriteConfigurator

+ WriteConfigure func(wc *WriteConfig)

Jan 4, 2023

Changes in this version

+ func WriteExcelTo(w io.Writer, data [][]string) error

+ func WriteTo(w io.Writer, ts []T) error

Dec 12, 2022

Changes in this version

+ type Configurator interface

+ Configure func(c C)

+ type ReadConfig struct

+ DataStartRowIndex int

+ HeaderRowIndex int

+ SheetIndex int

+ TagName string

+ TrimSpace bool

+ type ReadConfigurator interface

+ type WriteConfig struct

+ SheetName string

+ TagName string

+ type WriteConfigurator interface

Dec 9, 2022

Changes in this version

+ var ErrDataStartRowIndexOutOfRange = errors.New("exl: data start row index out of range")

+ var ErrHeaderRowIndexOutOfRange = errors.New("exl: header row index out of range")

+ var ErrSheetIndexOutOfRange = errors.New("exl: sheet index out of range")

+ type Writer struct

+ func NewWriter(options ...xlsx.FileOption) *Writer

+ func (w *Writer) SaveTo(path string) (err error)

+ func (w *Writer) Write(sheet string, data any) error

+ func (w *Writer) WriteTo(dw io.Writer) (n int, err error)

Sep 28, 2022

Changes in this version

type ReadBind

+ Read func(rm *ReadMetadata)

type WriteBind

+ Write func(wm *WriteMetadata)

Jun 24, 2022

Changes in this version

type ReadBind

+ ConfigureRM func(rm *ReadMetadata)

type WriteBind

+ ConfigureWM func(wm *WriteMetadata)

Apr 22, 2022

Changes in this version

type ReadMetadata

+ TrimSpace bool

Apr 20, 2022

Changes in this version

+ func Read(reader io.Reader, bind T) ([]T, error)

+ func ReadBinary(bytes []byte, bind T) ([]T, error)

+ func ReadExcel(file string, sheetIndex int, walk func(index int, rows *xlsx.Row)) error

+ func ReadFile(file string, bind T) ([]T, error)

+ func Write(file string, ts []T) error

+ func WriteExcel(file string, data [][]string) error

+ type ReadBind interface

+ ReadMetadata func() *ReadMetadata

+ type ReadMetadata struct

+ DataStartRowIndex int

+ HeaderRowIndex int

+ SheetIndex int

+ TagName string

+ type WriteBind interface

+ WriteMetadata func() *WriteMetadata

+ type WriteMetadata struct

+ SheetName string

+ TagName string