ods

README

ods2csv

This is a Go package to read contents of a .ods (openoffice spreadsheet) file. Formula, value or date in a cell can be accessed. See example for usage. This library is made to demonstrate the capability of "https://github.com/LIJUCHACKO/XmlDB" (A native xml database)

Note: Merged cells are not support

Documentation

Index

• func ReadSheetThread(DB *xmlDB.Database, spreadsheet int, chres chan Result)
• func ReplaceHTMLSpecialEntities(input string) string
• type Cell
• type Odsfile
  • func ReadODSFile(odsfilename string) (Odsfile, error)
• type Result
• type Row
• type Sheet
  • func ReadSheet(DB *xmlDB.Database, spreadsheet int) (Sheet, error)

Functions

func ReadSheetThread

func ReadSheetThread(DB *xmlDB.Database, spreadsheet int, chres chan Result)

func ReplaceHTMLSpecialEntities

func ReplaceHTMLSpecialEntities(input string) string

Types

type Cell

type Cell struct {
	Type      string //Type float,string ...    ( office:value-type= )
	Value     string //Value                    ( office:value= )
	DateValue string //DateValue                ( office:date-value= )
	Formula   string //formula                  ( table:formula= )
	Text      string //Text

}

type Odsfile

type Odsfile struct {
	Sheets []Sheet
}

func ReadODSFile

func ReadODSFile(odsfilename string) (Odsfile, error)

type Result

type Result struct {
	Sheeti Sheet
	// contains filtered or unexported fields
}

type Row

type Row struct {
	Cells []Cell
}

type Sheet

type Sheet struct {
	Name string
	Rows []Row
}

func ReadSheet

func ReadSheet(DB *xmlDB.Database, spreadsheet int) (Sheet, error)