table

package
v1.4.1 Latest Latest
Warning

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

 Go to latest Published: May 27, 2021 License: MIT Imports: 22 Imported by: 1

Documentation

Index

Constants

View Source 
const (
	ExcelMaxColCount = 16384
	ExcelMaxRowCount = 1048576
	Alphabet         = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
	ZZ               = uint32(702)
	ZZIndex          = uint32(701)
)
View Source 
const StyleSimple = "border:1px solid #000;border-collapse:collapse"

Variables

View Source 
var DebugReadCSV = false // should not need to use this.

Functions

func ColIndexToLetters 

func ColIndexToLetters(colIndex uint32) string

func ColNumberToLetters 

func ColNumberToLetters(colNumber uint32) string

func CoordinateNumbersToSheetLocation 

func CoordinateNumbersToSheetLocation(colNum, rowNum uint32) string

CoordinateNumbersToSheetLocation converts x, y integer coordinates to a spreadsheet location such as "AA1" for col 27, row 1.

func CoordinatesToSheetLocation 

func CoordinatesToSheetLocation(colIdx, rowIdx uint32) string

CoordinatesToSheetLocation converts x, y integer coordinates to a spreadsheet location such as "AA1" for col 27, row 1.

func FormatDateAndFloats added in v1.3.0 

func FormatDateAndFloats(val string, colIdx uint) (interface{}, error)

func FormatMonthAndFloats added in v1.3.0 

func FormatMonthAndFloats(val string, colIdx uint) (interface{}, error)

func FormatStringAndFloats 

func FormatStringAndFloats(val string, colIdx uint) (interface{}, error)

func FormatStringAndInts 

func FormatStringAndInts(val string, colIdx uint) (interface{}, error)

func FormatStrings 

func FormatStrings(val string, col uint) (interface{}, error)

func FormatTimeAndFloats 

func FormatTimeAndFloats(val string, colIdx uint) (interface{}, error)

func FormatTimeAndInts 

func FormatTimeAndInts(val string, colIdx uint) (interface{}, error)

func ReadCSVFileSingleColumnValuesString 

func ReadCSVFileSingleColumnValuesString(filename, sep string, hasHeader, trimSpace bool, col uint, condenseUniqueSort bool) ([]string, error)

func ReadCSVFilesSingleColumnValuesString 

func ReadCSVFilesSingleColumnValuesString(files []string, sep string, hasHeader, trimSpace bool, col uint, condenseUniqueSort bool) ([]string, error)

func SimpleTable 

func SimpleTable(table Table) string

func StreamSimpleTable 

func StreamSimpleTable(qw422016 *qt422016.Writer, table Table)

func ToDocuments 

func ToDocuments(tbl *Table) []map[string]interface{}

func ToHTML 

func ToHTML(tbl *Table, escapeHTML bool) string

ToHTML converts `*TableData` to HTML.

func WriteCSV 

func WriteCSV(path string, t *Table) error

WriteCSV writes the table as a CSV.

func WriteCSVSimple 

func WriteCSVSimple(cols []string, records [][]string, filename string) error

WriteCSVSimple writes a file with cols and records data.

func WriteSimpleTable 

func WriteSimpleTable(qq422016 qtio422016.Writer, table Table)

func WriteXLSX 

func WriteXLSX(path string, tables ...*Table) error

WriteXLSX writes a table as an Excel XLSX file with row formatter option.

func WriteXLSXInterface 

func WriteXLSXInterface(filename string, sheetdatas ...SheetData) error

Types

type Column added in v0.0.4 

type Column struct {
	Display string
	Slug    string
	Width   float64
}

type ColumnSet added in v0.0.4 

type ColumnSet struct {
	Columns []Column
}

func (*ColumnSet) DisplayTexts added in v0.0.4 

func (set *ColumnSet) DisplayTexts() []string

type SheetData 

type SheetData struct {
	SheetName string
	Rows      [][]interface{}
}

type Table 

type Table struct {
	Name           string
	Columns        []string
	Records        [][]string
	FormatMap      map[int]string
	FormatFunc     func(val string, colIdx uint) (interface{}, error)
	FormatAutoLink bool
	ID             string
	Class          string
	Style          string
}

Table is useful for working on CSV data

func FormatStraightToTabular 

func FormatStraightToTabular(tbl Table, colCount uint) (Table, error)

FormatStraightToTabular takes a "straight table" wheere the columnn names and values are in a single column and lays it out as a standard tabular data.

func NewTable 

func NewTable() Table

func ParseBytes 

func ParseBytes(data []byte, delimiter rune, hasHeaderRow bool) (Table, error)

func ParseReader 

func ParseReader(reader io.Reader, delimiter rune, hasHeaderRow bool) (Table, error)

func ReadFile 

func ReadFile(path string, comma rune, hasHeader, stripBom bool) (Table, error)

ReadFile reads in a delimited file and returns a `Table` struct.

func ReadFileSimple added in v1.3.0 

func ReadFileSimple(path string, sep string, hasHeader, trimSpace bool) (Table, error)

func ReadFilesSimple added in v1.3.0 

func ReadFilesSimple(filenames []string, sep string, hasHeader, trimSpace bool) (Table, error)

func (*Table) ColumnIndex 

func (tbl *Table) ColumnIndex(colName string) int

func (*Table) ColumnSumFloat64 

func (tbl *Table) ColumnSumFloat64(colIdx uint) (float64, error)

func (*Table) ColumnValues 

func (tbl *Table) ColumnValues(colIdx uint, wantUnique, wantSort bool) ([]string, error)

func (*Table) ColumnValuesDistinct 

func (tbl *Table) ColumnValuesDistinct(colIdx uint) (map[string]int, error)

func (*Table) ColumnValuesMinMax 

func (tbl *Table) ColumnValuesMinMax(colIdx uint) (string, string, error)

func (*Table) ColumnsValuesDistinct 

func (tbl *Table) ColumnsValuesDistinct(wantCols []string, stripSpace bool) (map[string]int, error)

func (*Table) FilterRecordsColumnValues 

func (tbl *Table) FilterRecordsColumnValues(wantColNameValues map[string]string) ([][]string, error)

FilterRecordsColumnValues returns a set of records filtered by column names and column values.

func (*Table) FormatterFunc 

func (tbl *Table) FormatterFunc() func(val string, colIdx uint) (interface{}, error)

func (*Table) IsWellFormed 

func (tbl *Table) IsWellFormed() (isWellFormed bool, columnCount uint)

func (*Table) LoadMergedRows 

func (tbl *Table) LoadMergedRows(data [][]string)

LoadMergedRows is used to load data from `[][]string` sources like csv.ReadAll()

func (*Table) NewTableFilterColDistinctFirst 

func (tbl *Table) NewTableFilterColDistinctFirst(colIdx int) *Table

func (*Table) NewTableFilterColumnValues 

func (tbl *Table) NewTableFilterColumnValues(wantColNameValues map[string]string) (Table, error)

NewTableFilterColumnValues returns a Table filtered by column names and column values.

func (*Table) RecordToMSS 

func (tbl *Table) RecordToMSS(record []string) map[string]string

func (*Table) RecordValue 

func (tbl *Table) RecordValue(wantCol string, record []string) (string, error)

func (*Table) RecordValueOrEmpty 

func (tbl *Table) RecordValueOrEmpty(wantCol string, record []string) string

func (*Table) ToSliceMSS 

func (tbl *Table) ToSliceMSS() []map[string]string

func (*Table) Unmarshal 

func (tbl *Table) Unmarshal(funcRecord func(record []string) error) error

Unmarshal is a convenience function to provide a simple interface to unmarshal table contents into any desired output.

func (*Table) UpsertRowColumnValue 

func (tbl *Table) UpsertRowColumnValue(rowIdx, colIdx uint, value string)

func (*Table) WriteCSV 

func (tbl *Table) WriteCSV(path string) error

func (*Table) WriteJSON 

func (tbl *Table) WriteJSON(path string, perm os.FileMode, jsonPrefix, jsonIndent string) error

func (*Table) WriteXLSX 

func (tbl *Table) WriteXLSX(path, sheetname string) error

type TableSet 

type TableSet struct {
	Columns      []string
	RowFormatter func(val string, col uint) (interface{}, error)
	TableMap     map[string]*Table
}

func (*TableSet) AddRecord 

func (ts *TableSet) AddRecord(tableName string, row []string)

func (*TableSet) TableNames 

func (ts *TableSet) TableNames() []string

func (*TableSet) TablesSorted 

func (ts *TableSet) TablesSorted() []*Table

type TabulatorColumn added in v0.0.4 

type TabulatorColumn struct {
	Title        string  `json:"title,omitempty"`
	Field        string  `json:"field,omitempty"`
	Width        float64 `json:"width,omitempty"`
	HeaderFilter string  `json:"headerFilter,omitempty"`
}

type TabulatorColumnSet added in v0.0.4 

type TabulatorColumnSet struct {
	Columns []TabulatorColumn
}

func BuildColumnsTabulator added in v0.0.4 

func BuildColumnsTabulator(columns []Column) TabulatorColumnSet

func (*TabulatorColumnSet) ColumnsJSON added in v0.0.4 

func (tColSet *TabulatorColumnSet) ColumnsJSON() ([]byte, error)

func (*TabulatorColumnSet) MustColumnsJSON added in v0.0.4 

func (tColSet *TabulatorColumnSet) MustColumnsJSON() []byte

Source Files

View all Source files

Directories

Path Synopsis
examples
simple

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.