excel

Documentation

Index

• type Excel
  • func New() *Excel
  • func OpenFile(filename string, opt ...Option) (*Excel, error)
  • func OpenReader(r io.Reader, opt ...Option) (*Excel, error)
  • func (e *Excel) GetRows(index int, options ...ReadOption) ([][]string, bool, error)
  • func (e *Excel) Rows(index int) (*excelize.Rows, error)
  • func (e *Excel) Size(index int) (row int, column int, err error)
• type Option
• type ReadConfig
• type ReadOption
  • func WithMaxColumn(maxColumn int) ReadOption
  • func WithMaxRow(maxRow int) ReadOption
• type Size

Types

type Excel

type Excel struct {
	// contains filtered or unexported fields
}

Excel excel

func New

func New() *Excel

New create a new excel

func OpenFile

func OpenFile(filename string, opt ...Option) (*Excel, error)

func OpenReader

func OpenReader(r io.Reader, opt ...Option) (*Excel, error)

func (*Excel) GetRows

func (e *Excel) GetRows(index int, options ...ReadOption) ([][]string, bool, error)

GetRows get all rows with row and column limit. Default Row limit is 8192. when exceed will set hasMore=true. Default Column limit is 1000. when exceed will cause ErrTooManyColumn

func (*Excel) Rows

func (e *Excel) Rows(index int) (*excelize.Rows, error)

Rows return rows by sheet index

func (*Excel) Size

func (e *Excel) Size(index int) (row int, column int, err error)

Size returns the row count and max column count of a sheet

type Option

type Option = excelize.Options

type ReadConfig

type ReadConfig struct {
	MaxRow    int
	MaxColumn int
}

type ReadOption

type ReadOption func(opt *ReadConfig)

func WithMaxColumn

func WithMaxColumn(maxColumn int) ReadOption

WithMaxColumn set the max column to read when get all rows

func WithMaxRow

func WithMaxRow(maxRow int) ReadOption

WithMaxRow set the max row to read when get all rows

type Size

type Size struct {
	Row    int
	Column int
}

Size record for excel sheet size