excel

package

v0.10.11 Latest Latest Go to latest Published: May 22, 2024 License: MIT Imports: 3 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

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