xlsx

README

go-xlsx

Simple Excel (Office Open XML) reader

Documentation

Index

• func OpenAsCellSlice(filePath string) ([][]Cell, error)
• func OpenAsStringSlice(filePath string) ([][]string, error)
• func ReadFileByRow(filePath string) (fileData chan []Cell, err error)
• type Cell
  • func (cell Cell) ExcelTime() time.Time
  • func (cell Cell) Float() float64
  • func (cell Cell) Int() int
  • func (cell Cell) String() string
  • func (cell Cell) Time(layout string) time.Time
• type Sheet
• type Workbook

Functions

func OpenAsCellSlice

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

OpenAsCellSlice returns all data from specified file as cells

func OpenAsStringSlice

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

OpenAsStringSlice returns all data from specified file as strings

func ReadFileByRow

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

ReadFileByRow returns data from specified file by row

Types

type Cell

type Cell string

Cell represents table cell

func (Cell) ExcelTime

func (cell Cell) ExcelTime() time.Time

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

func (Cell) Float

func (cell Cell) Float() float64

Float returns cell data as float64

func (Cell) Int

func (cell Cell) Int() int

Int returns cell data as integer

func (Cell) String

func (cell Cell) String() string

String returns cell data as string

func (Cell) Time

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

Time returns cell parsed time with specified layout

type Sheet

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

Sheet represents Excel sheet

type Workbook

type Workbook struct {
	Sheet *Sheet
}

Workbook represents Excel workbook