excel

package
v0.0.0-...-f3f1d68 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 28, 2025 License: Apache-2.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func ParseTargetsFromExcel

func ParseTargetsFromExcel(file *multipart.FileHeader) (string, error)

Types

type ExcelParser

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

nolint

func NewExcelParser

func NewExcelParser(ctx context.Context, filePath string, ops ...ParserWithOption) (*ExcelParser, error)

NewExcelParser 创建excel的解析器

func (*ExcelParser) AsyncReadAllRows

func (ep *ExcelParser) AsyncReadAllRows(ctx context.Context, sheet string) (<-chan []string, error)

AsyncReadAllRows 异步读取指定sheet的所有数据

func (*ExcelParser) GetFileObject

func (ep *ExcelParser) GetFileObject() *excelize.File

func (*ExcelParser) ReadRows

func (ep *ExcelParser) ReadRows(ctx context.Context, sheet string, rowsNum int) (dataList [][]string, err error)

rowsNum: 指定行数, 如果小于0, 则是所有行数据; 如果rowsNum>实际行数, 返回所有行数据

func (*ExcelParser) Save

func (ep *ExcelParser) Save(ctx context.Context) error

Save 保存文件

func (*ExcelParser) WriteRow

func (ep *ExcelParser) WriteRow(ctx context.Context, sheet string, row int, data []interface{}) error

WriteData 写入数据到指定的工作表

func (*ExcelParser) WriteRows

func (ep *ExcelParser) WriteRows(ctx context.Context, sheet string, startRow int, data [][]interface{}) error

WriteRows 写入数据到指定的工作表

type ParserWithOption

type ParserWithOption func(*ExcelParser)

func WithLogger

func WithLogger(logg logger.Logger) ParserWithOption

Jump to

Keyboard shortcuts

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