excel

package

v1.4.3 Latest Latest Go to latest Published: May 11, 2023 License: GPL-3.0 Imports: 7 Imported by: 1

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 FileData struct {
	// contains filtered or unexported fields
}

FileData Excel文件结构

func NewExcel(filename string) (*FileData, error)

NewExcel 创建新的excel文件 filename: 需要保存的文件路径，可不加扩展名返回：excel数据格式，错误

func NewExcelFromBinary(bs []byte, filename string) (*FileData, error)

NewExcelFromBinary 从文件读取xlsx

func (fd *FileData) AddRow(cells ...interface{})

AddRow 在当前sheet添加行 cells：每个单元格的数据，任意格式

func (fd *FileData) AddRowInSheet(sheetname string, cells ...interface{})

AddRowInSheet 在指定sheet添加行 cells：每个单元格的数据，任意格式

func (fd *FileData) AddSheet(sheetname string) (*xlsx.Sheet, error)

AddSheet 添加sheet sheetname sheet名称

func (fd *FileData) Save() (string, error)

Save 保存excel数据到文件返回保存的完整文件名，错误

func (fd *FileData) SetColume(columeName ...string)

SetColume 设置列头 columeName: 列头名，有多少写多少个

func (fd *FileData) Write(w io.Writer) error

Write 将excel数据写入到writer w： io.writer