xlsx

Documentation

Overview

Package xlsx provides the ability to extract text from Excel spreadsheets.

Index

• type Cell
  • func (c *Cell) Boolean() bool
  • func (c *Cell) Float() float64
  • func (c *Cell) Integer() int
  • func (c *Cell) String() string
  • func (c *Cell) Time() time.Time
• type CellType
• type Ref
  • func ParseRef(str string) Ref
  • func (r Ref) String() string
• type Sheet
  • func Load(path string) ([]Sheet, error)
  • func Read(in io.ReaderAt, size int64) ([]Sheet, error)

Types

type Cell

type Cell struct {
	Type  CellType
	Value string
}

Cell holds the contents of a cell.

func (*Cell) Boolean

func (c *Cell) Boolean() bool

Boolean returns the value of this cell as a boolean.

func (*Cell) Float

func (c *Cell) Float() float64

Float returns the value of this cell as an float.

func (*Cell) Integer

func (c *Cell) Integer() int

Integer returns the value of this cell as an integer.

func (*Cell) String

func (c *Cell) String() string

func (*Cell) Time

func (c *Cell) Time() time.Time

Time returns the value of this cell as a time.Time.

type CellType

type CellType int

CellType holds an enumeration of cell types.

const (
	String CellType = iota
	Number
	Boolean
)

Cell types.

type Ref

type Ref struct {
	Row int
	Col int
}

Ref holds a cell reference.

func ParseRef

func ParseRef(str string) Ref

ParseRef parses a string into a Ref.

func (Ref) String

func (r Ref) String() string

type Sheet

type Sheet struct {
	Name  string
	Min   Ref
	Max   Ref
	Cells map[Ref]Cell
}

Sheet holds the data contained in a single worksheet.

func Load

func Load(path string) ([]Sheet, error)

Load sheets from an .xlsx file.

func Read

func Read(in io.ReaderAt, size int64) ([]Sheet, error)

Read sheets from an .xlsx stream.