xls

package
v1.0.1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Oct 10, 2024 License: MIT Imports: 13 Imported by: 0

README

xls

Pure Golang xls library writen by Rongshu Tech (chinese), based on libxls.

Thanks for contributions from Tamás Gulácsi @tgulacsi, @flyin9.

Basic Usage

  • Use Open function for open file

  • Use OpenWithCloser function for open file and use the return value closer for close file

  • Use OpenReader function for open xls from a reader, you should close related file in your own code

  • Follow the example in GoDoc

Documentation

Index

Constants

View Source 
const (
	MJD_0      float64 = 2400000.5
	MJD_JD2000 float64 = 51544.5
)

Variables

View Source 
var ErrIsInt = fmt.Errorf("is int")

Functions

This section is empty.

Types

type BlankCol 

type BlankCol struct {
	Col
	Xf uint16
}

func (*BlankCol) String 

func (c *BlankCol) String(wb *WorkBook) []string

type CellRange 

type CellRange struct {
	FirstRowB uint16
	LastRowB  uint16
	FristColB uint16
	LastColB  uint16
}

range type of multi cells in multi rows

func (*CellRange) FirstCol 

func (c *CellRange) FirstCol() uint16

func (*CellRange) FirstRow 

func (c *CellRange) FirstRow() uint16

func (*CellRange) LastCol 

func (c *CellRange) LastCol() uint16

func (*CellRange) LastRow 

func (c *CellRange) LastRow() uint16

type Col 

type Col struct {
	RowB      uint16
	FirstColB uint16
}

func (*Col) FirstCol 

func (c *Col) FirstCol() uint16

func (*Col) LastCol 

func (c *Col) LastCol() uint16

func (*Col) Row 

func (c *Col) Row() uint16

func (*Col) String 

func (c *Col) String(wb *WorkBook) []string

type Coler 

type Coler interface {
	Row() uint16
}

type Font 

type Font struct {
	Info *FontInfo
	Name string
}

type FontInfo 

type FontInfo struct {
	Height     uint16
	Flag       uint16
	Color      uint16
	Bold       uint16
	Escapement uint16
	Underline  byte
	Family     byte
	Charset    byte
	Notused    byte
	NameB      byte
}

type Format 

type Format struct {
	Head struct {
		Index uint16
		Size  uint16
	}
	// contains filtered or unexported fields
}

type FormulaCol 

type FormulaCol struct {
	Header struct {
		Col
		IndexXf uint16
		Result  [8]byte
		Flags   uint16
		// contains filtered or unexported fields
	}
	Bts []byte
}

func (*FormulaCol) String 

func (c *FormulaCol) String(wb *WorkBook) []string

type FormulaStringCol 

type FormulaStringCol struct {
	Col
	RenderedValue string
}

func (*FormulaStringCol) String 

func (c *FormulaStringCol) String(wb *WorkBook) []string
type HyperLink struct {
	CellRange
	Description      string
	TextMark         string
	TargetFrame      string
	Url              string
	ShortedFilePath  string
	ExtendedFilePath string
	IsUrl            bool
}

hyperlink type's content

func (*HyperLink) String 

func (h *HyperLink) String(wb *WorkBook) []string

get the hyperlink string, use the public variable Url to get the original Url

type LabelsstCol 

type LabelsstCol struct {
	Col
	Xf  uint16
	Sst uint32
}

func (*LabelsstCol) String 

func (c *LabelsstCol) String(wb *WorkBook) []string

type MulBlankCol 

type MulBlankCol struct {
	Col
	Xfs      []uint16
	LastColB uint16
}

func (*MulBlankCol) LastCol 

func (c *MulBlankCol) LastCol() uint16

func (*MulBlankCol) String 

func (c *MulBlankCol) String(wb *WorkBook) []string

type MulrkCol 

type MulrkCol struct {
	Col
	Xfrks    []XfRk
	LastColB uint16
}

func (*MulrkCol) LastCol 

func (c *MulrkCol) LastCol() uint16

func (*MulrkCol) String 

func (c *MulrkCol) String(wb *WorkBook) []string

type NumberCol 

type NumberCol struct {
	Col
	Index uint16
	Float float64
}

func (*NumberCol) String 

func (c *NumberCol) String(wb *WorkBook) []string

type RK 

type RK uint32

func (RK) Float 

func (rk RK) Float() (float64, error)

func (RK) String 

func (rk RK) String() string

type Ranger 

type Ranger interface {
	FirstRow() uint16
	LastRow() uint16
}

range type of multi rows

type RkCol 

type RkCol struct {
	Col
	Xfrk XfRk
}

func (*RkCol) String 

func (c *RkCol) String(wb *WorkBook) []string

type Row 

type Row struct {
	// contains filtered or unexported fields
}

Row the data of one row

func (*Row) Col 

func (r *Row) Col(i int) string

Col Get the Nth Col from the Row, if has not, return nil. Suggest use Has function to test it.

func (*Row) ColExact 

func (r *Row) ColExact(i int) string

ColExact Get the Nth Col from the Row, if has not, return nil. For merged cells value is returned for first cell only

func (*Row) FirstCol 

func (r *Row) FirstCol() int

FirstCol Get the number of First Col of the Row.

func (*Row) LastCol 

func (r *Row) LastCol() int

LastCol Get the number of Last Col of the Row.

type SstInfo 

type SstInfo struct {
	Total uint32
	Count uint32
}

type TWorkSheetVisibility 

type TWorkSheetVisibility byte
const (
	WorkSheetVisible    TWorkSheetVisibility = 0
	WorkSheetHidden     TWorkSheetVisibility = 1
	WorkSheetVeryHidden TWorkSheetVisibility = 2
)

type WorkBook 

type WorkBook struct {
	Is5ver   bool
	Type     uint16
	Codepage uint16
	Xfs      []st_xf_data
	Fonts    []Font
	Formats  map[uint16]*Format

	Author string
	// contains filtered or unexported fields
}

xls workbook type

func Open 

func Open(file string, charset string) (*WorkBook, error)

Open one xls file

func OpenReader 

func OpenReader(reader io.ReadSeeker, charset string) (wb *WorkBook, err error)

Open xls file from reader

func OpenWithCloser 

func OpenWithCloser(file string, charset string) (*WorkBook, io.Closer, error)

Open one xls file and return the closer

func (*WorkBook) GetSheet 

func (w *WorkBook) GetSheet(num int) *WorkSheet

Get one sheet by its number

func (*WorkBook) NumSheets 

func (w *WorkBook) NumSheets() int

Get the number of all sheets, look into example

func (*WorkBook) Parse 

func (w *WorkBook) Parse(buf io.ReadSeeker)

func (*WorkBook) ReadAllCells 

func (w *WorkBook) ReadAllCells(max int) (res [][]string)

helper function to read all cells from file Notice: the max value is the limit of the max capacity of lines. Warning: the helper function will need big memeory if file is large.

type WorkSheet 

type WorkSheet struct {
	Name       string
	Selected   bool
	Visibility TWorkSheetVisibility

	// NOTICE: this is the max row number of the sheet, so it should be count -1
	MaxRow uint16
	// contains filtered or unexported fields
}

WorkSheet in one WorkBook

func (*WorkSheet) Row 

func (w *WorkSheet) Row(i int) *Row

type Xf5 

type Xf5 struct {
	Font      uint16
	Format    uint16
	Type      uint16
	Align     uint16
	Color     uint16
	Fill      uint16
	Border    uint16
	Linestyle uint16
}

type Xf8 

type Xf8 struct {
	Font        uint16
	Format      uint16
	Type        uint16
	Align       byte
	Rotation    byte
	Ident       byte
	Usedattr    byte
	Linestyle   uint32
	Linecolor   uint32
	Groundcolor uint16
}

type XfRk 

type XfRk struct {
	Index uint16
	Rk    RK
}

func (*XfRk) String 

func (xf *XfRk) String(wb *WorkBook) string

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.