xlsx

package
v0.0.0-...-9f9e314 Latest Latest
Warning

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

Go to latest
Published: Aug 24, 2022 License: GPL-3.0 Imports: 7 Imported by: 0

README

excel工具

用来读取excel导出luatable格式,excel的格式参考样例支持以下类型

字段 类型 导出格式说明
string 字符串 导出时加双引号
int 整型 导出数字
raw 直接导出
comment 注释 跳过

TODO

  • base格式的导出
  • tiny格式的导出

Documentation

Index

Constants

This section is empty.

Variables

View Source
var ErrNoContent = errors.New("内容为空")

Functions

func DefaultFilterFunc

func DefaultFilterFunc(filter string, dest string) bool

func SheetToSlice

func SheetToSlice(sheet *excel.Sheet) ([][]string, error)

SheetToSlice 将Sheet转成二维数组

Types

type FilterFunc

type FilterFunc func(filter string, dest string) bool

FilterFunc 过滤器

type Reader

type Reader interface {
	SetFilterFunc(filterFunc FilterFunc)
	ReadAll() ([]byte, error)
}

func New

func New(typ string) Reader

func NewBaseReader

func NewBaseReader(name string, src [][]string, filter string, keyCount,
	filterRow, keyRow, typeRow, firstRow int) Reader

NewBaseReader 创建一个Reader,用来读取excel 文件

func NewTinyReader

func NewTinyReader(name string, src [][]string, filter string, filterCol, keyCol, typeCol, valueCol int) Reader

type SheetType

type SheetType int
const (
	SheetInvalid SheetType = iota
	SheetBase
	SheetTiny
	SheetEnd // end of defines
)

func StringToSheetType

func StringToSheetType(typeStr string) (SheetType, bool)

StringToSheetType 将string转换成SheetType

func (SheetType) ToString

func (t SheetType) ToString() string

ToString 输出对应的SheetType string

Jump to

Keyboard shortcuts

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