excel

Documentation

Overview

Package excel @Description TODO 不够好 @Author jiangyang @Created 2020/12/7 11:10 上午

Index

• Constants
• func Axis(i, j int) string
• func FileNameOption(fileName string) *fileNameOpt
• func GetStructType(t reflect.Type) reflect.Type
• func SheetNameOption(sheetName string) *sheetNameOpt
• func TitleOption(titles ...string) *titleOpt
• type Excel
  • func New(options ...Option) *Excel
  • func (e *Excel) Check() error
  • func (e *Excel) Create(data interface{}) error
  • func (e *Excel) Insert(data interface{}) error
  • func (e *Excel) Read(data interface{}) error
  • func (e *Excel) Save(data interface{}) error
• type ExcelOption
• type Option

Constants

const (
	StructTag = "excel"
)

Functions

func Axis

func Axis(i, j int) string

获取Excel坐标名

func FileNameOption

func FileNameOption(fileName string) *fileNameOpt

func GetStructType

func GetStructType(t reflect.Type) reflect.Type

func SheetNameOption

func SheetNameOption(sheetName string) *sheetNameOpt

func TitleOption

func TitleOption(titles ...string) *titleOpt

Types

type Excel

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

func New

func New(options ...Option) *Excel

func (*Excel) Check

func (e *Excel) Check() error

func (*Excel) Create

func (e *Excel) Create(data interface{}) error

Create 创建Excel (覆盖原文件)

func (*Excel) Insert

func (e *Excel) Insert(data interface{}) error

Insert 编辑Excel

func (*Excel) Read

func (e *Excel) Read(data interface{}) error

读取Excel 第一行为表头 data: []struct

func (*Excel) Save

func (e *Excel) Save(data interface{}) error

Save 保存

type ExcelOption

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

type Option

type Option interface {
	// contains filtered or unexported methods
}