excel

package

v0.10.17 Latest Latest Go to latest Published: Jul 26, 2024 License: MIT Imports: 3 Imported by: 0

Details

This section is empty.

This section is empty.

This section is empty.

type Cell struct {
	Row Row
	Col Col

} // 单元格

type Col string // 列

func (c Col) ToString() string

type Read struct {
	Lu    Cell   // 左上单元格坐标
	Rd    Cell   // 右下单元格坐标
	Sheet string // 工作表名称
	// contains filtered or unexported fields
}

func NewRead(opts ...ReadOption) *Read

func (r *Read) Print()

Print 打印

func (r *Read) Read() ([][]string, error)

Read 读取excel文件

type ReadOption func(*Read)

func WithFile(file string) ReadOption

func WithLu(lu Cell) ReadOption

func WithRd(rd Cell) ReadOption

func WithSheet(sheet string) ReadOption

type Row int // 行

func (r Row) ToInt() int

type Write struct {
	Filepath string     // 文件路径
	Sheet    string     // 工作表名称
	Head     []string   // 表头
	Data     [][]string // 数据
}

func NewWrite(opts ...WriteOption) *Write

func (w *Write) Write() (string, error)

type WriteOption func(*Write)

func WithData(data [][]string) WriteOption

func WithFilepath(filepath string) WriteOption

func WithHead(head []string) WriteOption

func WithWriteSheet(sheet string) WriteOption

Path	Synopsis
test