xlsxUtil

Documentation

Index

• func AddArray2Row(rows []string, row *xlsx.Row)
• func AddMap2Row(item map[string]string, keys []string, row *xlsx.Row)
• func AddMapArray2Sheet(array []map[string]string, keys []string, sheet *xlsx.Sheet)
• func AddSheet(excel *xlsx.File, sheetName string) *xlsx.Sheet
• func AddSheets(excel *xlsx.File, sheetNames []string)
• func AddSlice2Sheet(slice [][]string, sheet *xlsx.Sheet)
• func GetRowArray(idx int, sheet *xlsx.Sheet) (rowArray []string)
• type File
  • func NewFile() *File
  • func OpenFile(fileName string) *File
  • func (excel *File) AddSheet(sheetName string) *xlsx.Sheet
  • func (excel *File) AppendSheet(sheet xlsx.Sheet, sheetName string) *xlsx.Sheet
  • func (excel *File) Save(path string)

Functions

func AddArray2Row

func AddArray2Row(rows []string, row *xlsx.Row)

func AddMap2Row

func AddMap2Row(item map[string]string, keys []string, row *xlsx.Row)

func AddMapArray2Sheet

func AddMapArray2Sheet(array []map[string]string, keys []string, sheet *xlsx.Sheet)

func AddSheet

func AddSheet(excel *xlsx.File, sheetName string) *xlsx.Sheet

func AddSheets

func AddSheets(excel *xlsx.File, sheetNames []string)

func AddSlice2Sheet

func AddSlice2Sheet(slice [][]string, sheet *xlsx.Sheet)

func GetRowArray

func GetRowArray(idx int, sheet *xlsx.Sheet) (rowArray []string)

Types

type File

type File struct {
	File *xlsx.File
}

func NewFile

func NewFile() *File

func OpenFile

func OpenFile(fileName string) *File

func (*File) AddSheet

func (excel *File) AddSheet(sheetName string) *xlsx.Sheet

func (*File) AppendSheet

func (excel *File) AppendSheet(sheet xlsx.Sheet, sheetName string) *xlsx.Sheet

func (*File) Save

func (excel *File) Save(path string)