excel

Documentation

Index

• func GetFilteredRows(r io.Reader, sheet string, rowLength, skipRow int, opt ...excelize.Options) ([][]string, error)
• func GetRows(r io.Reader, sheet string, opt ...excelize.Options) ([][]string, error)
• func ReadRows(r io.Reader, sheet string, handler ReadHandler, opt ...excelize.Options) error
• func WriteRows(r io.Reader, sheet, saveAs string, handler WriteHandler, ...) error
• type ReadHandler
• type WriteHandler

Functions

func GetFilteredRows

func GetFilteredRows(r io.Reader, sheet string, rowLength, skipRow int, opt ...excelize.Options) ([][]string, error)

GetFilteredRows 获取 excel 表上的所有大于等于指定行长度的行数据（忽略前 skipRow 行）

func GetRows

func GetRows(r io.Reader, sheet string, opt ...excelize.Options) ([][]string, error)

GetRows 获取 excel 表上的所有行数据

func ReadRows

func ReadRows(r io.Reader, sheet string, handler ReadHandler, opt ...excelize.Options) error

ReadRows 流式读取处理 excel 表上的行数据

func WriteRows

func WriteRows(r io.Reader, sheet, saveAs string, handler WriteHandler, opt ...excelize.Options) error

WriteRows 流式写入行数据至指定 excel 表中

Types

type ReadHandler

type ReadHandler func(rowNum int, columns []string) (isContinue bool)

ReadHandler 流式读取处理器

type WriteHandler

type WriteHandler func(rowNum int) (columns []interface{}, needWrite, isContinue bool)

WriteHandler 流式写入处理器