excel

Documentation

Index

• type Data
• type DataRow
• type Excel
• type FileInfo
• type KeyValue
• type Sheet

Types

type Data

type Data struct {
	Name   string
	Sheets []Sheet
}

Data represents the information about excel data

type DataRow

type DataRow struct {
	Data []KeyValue
}

DataRow represents the information about excel row

type Excel

type Excel interface {
	ReadSample() (*Data, error)
	ReadSheet(sheetName string) (*Sheet, error)
	ReadRow(sheetName string, exec func(row DataRow) error) error
}

Excel represents the functionalities required to read and write Excel files

type FileInfo

type FileInfo struct {
	Name       string
	FilePath   string
	FileReader io.Reader
}

FileInfo represents the information about a file

type KeyValue

type KeyValue struct {
	Header string
	Value  string
}

KeyValue represents the information about each cell in a sheet

type Sheet

type Sheet struct {
	Name    string
	DataRow []DataRow
}

Sheet represents the information about excel sheet