excelutil

README

excelutil

Utility library for working with Excel documents. Uses excelize library

Documentation

Index

• func AdvanceCol(current string, step int) (string, error)
• func AdvanceRow(current string, step int) (string, error)
• func Cr2s(c, r int) string
• func S2cr(s string) (int, int)
• func WriteRow2Excel(x *excelize.File, sheet string, row []interface{}, c, r int)
• func WriteStringRow2Excel(x *excelize.File, sheet string, row []string, c, r int)
• type ExcelModel
  • func NewExcelModel(h []string, l int) *ExcelModel
  • func (e *ExcelModel) AddRow(row map[string]interface{}) error
  • func (e *ExcelModel) Write2File(f *excelize.File, sheetName, topLeft string) (string, error)

Functions

func AdvanceCol

func AdvanceCol(current string, step int) (string, error)

func AdvanceRow

func AdvanceRow(current string, step int) (string, error)

func Cr2s

func Cr2s(c, r int) string

func S2cr

func S2cr(s string) (int, int)

func WriteRow2Excel

func WriteRow2Excel(x *excelize.File, sheet string, row []interface{}, c, r int)

func WriteStringRow2Excel

func WriteStringRow2Excel(x *excelize.File, sheet string, row []string, c, r int)

Types

type ExcelModel

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

func NewExcelModel

func NewExcelModel(h []string, l int) *ExcelModel

func (*ExcelModel) AddRow

func (e *ExcelModel) AddRow(row map[string]interface{}) error

func (*ExcelModel) Write2File

func (e *ExcelModel) Write2File(f *excelize.File, sheetName, topLeft string) (string, error)