table

package
v2.1.1+incompatible Latest Latest
Warning

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

 Go to latest Published: Sep 3, 2020 License: MIT Imports: 17 Imported by: 1

Documentation

Index

Constants

View Source 
const (
	ExcelMaxColCount = 16384
	ExcelMaxRowCount = 1048576
	Alphabet         = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
	ZZ               = uint32(702)
	ZZIndex          = uint32(701)
)

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 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 MergeFilterCSVFilesToJSON 

func MergeFilterCSVFilesToJSON(inPaths []string, outPath string, inComma rune, inStripBom bool, perm os.FileMode, andFilter map[string]stringsutil.MatchInfo) 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 ToDocuments 

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

func ToHTML 

func ToHTML(tbl *TableData, domID string, escapeHTML bool) string

ToHTML converts `*TableData` to HTML.

func WriteCSV 

func WriteCSV(path string, t *TableData) 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 WriteXLSX 

func WriteXLSX(path string, tbls ...*TableData) 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 DocumentsSet 

type DocumentsSet struct {
	Meta      DocumentsSetMeta    `json:"meta"`
	Documents []map[string]string `json:"records"`
}

func NewDocumentsSet 

func NewDocumentsSet() DocumentsSet

func ReadMergeFilterCSVFiles 

func ReadMergeFilterCSVFiles(inPaths []string, outPath string, inComma rune, inStripBom bool, andFilter map[string]stringsutil.MatchInfo) (DocumentsSet, error)

func (*DocumentsSet) CreateHistogram 

func (ds *DocumentsSet) CreateHistogram(key string)

func (*DocumentsSet) Inflate 

func (ds *DocumentsSet) Inflate()

type DocumentsSetMeta 

type DocumentsSetMeta struct {
	Count      int                            `json:"count"`
	Histograms map[string]histogram.Histogram `json:"histograms"`
}

func NewDocumentsSetMeta 

func NewDocumentsSetMeta() DocumentsSetMeta

type SheetData 

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

type TableData added in v1.0.0 

type TableData struct {
	Name       string
	Columns    []string
	Records    [][]string
	FormatMap  map[int]string
	FormatFunc func(val string, colIdx uint) (interface{}, error)
}

TableData is useful for working on CSV data

func NewTableData added in v1.0.0 

func NewTableData() TableData

func NewTableDataFileCSV added in v1.1.0 

func NewTableDataFileCSV(path string, comma rune, stripBom bool) (TableData, error)

NewTableDataFileCSV reads in a CSV file and returns a TableData struct.

func NewTableDataFileSimple added in v1.1.0 

func NewTableDataFileSimple(path string, sep string, hasHeader, trimSpace bool) (TableData, error)

func NewTableDataFilesSimple added in v1.1.0 

func NewTableDataFilesSimple(filenames []string, sep string, hasHeader, trimSpace bool) (TableData, error)

func (*TableData) ColIndex added in v1.1.0 

func (t *TableData) ColIndex(colName string) int

func (*TableData) ColValuesByColName added in v1.1.0 

func (t *TableData) ColValuesByColName(colName string) ([]string, error)

func (*TableData) ColumnIndex added in v1.0.0 

func (t *TableData) ColumnIndex(wantCol string) int

func (*TableData) ColumnValuesDistinct added in v1.0.0 

func (t *TableData) ColumnValuesDistinct(wantCol string) (map[string]int, error)

func (*TableData) ColumnValuesMinMax added in v1.0.0 

func (t *TableData) ColumnValuesMinMax(wantCol string) (string, string, error)

func (*TableData) ColumnsValuesDistinct added in v1.0.0 

func (t *TableData) ColumnsValuesDistinct(wantCols []string, stripSpace bool) (map[string]int, error)

func (*TableData) FilterRecords added in v1.0.0 

func (t *TableData) FilterRecords(wantColNameValues map[string]string) ([][]string, error)

func (*TableData) FormatterFunc added in v1.1.0 

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

func (*TableData) LoadMergedRows added in v1.0.0 

func (t *TableData) LoadMergedRows(data [][]string)
func NewTableDataCSV(path string, comma rune, stripBom bool) (TableData, error) {
	tbl := NewTableData()
	csv, file, err := csvutil.NewReader(path, comma, stripBom)
	if err != nil {
		return tbl, err
	}
	defer file.Close()
	mergedRows, err := csv.ReadAll()
	if err != nil {
		return tbl, err
	}
	tbl.LoadMergedRows(mergedRows)
	return tbl, nil
}

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

func (*TableData) NewTableFiltered added in v1.0.0 

func (t *TableData) NewTableFiltered(wantColNameValues map[string]string) (TableData, error)

func (*TableData) RecordToMSS added in v1.0.0 

func (t *TableData) RecordToMSS(record []string) map[string]string

func (*TableData) RecordValue added in v1.0.0 

func (t *TableData) RecordValue(wantCol string, record []string) (string, error)

func (*TableData) RecordValueOrEmpty added in v1.0.0 

func (t *TableData) RecordValueOrEmpty(wantCol string, record []string) string

func (*TableData) ToSliceMSS added in v1.0.0 

func (t *TableData) ToSliceMSS() []map[string]string

func (*TableData) WriteCSV added in v1.0.0 

func (t *TableData) WriteCSV(path string) error

func (*TableData) WriteJSON added in v1.0.0 

func (t *TableData) WriteJSON(path string, perm os.FileMode, jsonPrefix, jsonIndent string) error

func (*TableData) WriteXLSX added in v1.0.0 

func (t *TableData) WriteXLSX(path, sheetname string) error

type TableSet 

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

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() []*TableData

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.