xlsx

package module

v0.0.0-...-38b871a Latest Latest Go to latest Published: Nov 23, 2019 License: MIT Imports: 9 Imported by: 0

Details

Simple Excel (Office Open XML) reader

This section is empty.

This section is empty.

func OpenAsCellSlice(filePath string) ([][]Cell, error)

OpenAsCellSlice returns all data from specified file as cells

func OpenAsStringSlice(filePath string) ([][]string, error)

OpenAsStringSlice returns all data from specified file as strings

func ReadFileByRow(filePath string) (fileData chan []Cell, err error)

ReadFileByRow returns data from specified file by row

type Cell string

Cell represents table cell

func (cell Cell) ExcelTime() time.Time

ExcelTime returns cell time, if cell contains Excel date/time value

func (cell Cell) Float() float64

Float returns cell data as float64

func (cell Cell) Int() int

Int returns cell data as integer

func (cell Cell) String() string

String returns cell data as string

func (cell Cell) Time(layout string) time.Time

Time returns cell parsed time with specified layout

type Sheet struct {
	Name string
	Rows [][]Cell
}

Sheet represents Excel sheet

type Workbook struct {
	Sheet *Sheet
}

Workbook represents Excel workbook

Path	Synopsis
ooxml