excelizeutil

Documentation

Index

• Constants
• Variables
• func ColumnsTop(cols [][]string, trimSpace bool) []string
• func GetCellValue(f *excelize.File, sheetName string, colIdx, rowIdx uint, ...) (string, error)
• func SetRowValues(f *excelize.File, sheetName string, rowIndex uint, rowValues []any) error
• func StyleBackgroundColorSimple(hexRGBs []string) (*excelize.Style, error)
• type File
  • func NewFile(filename string) (*File, error)
  • func ReadFile(filename string) (*File, error)
  • func (f *File) Close() error
  • func (f *File) SheetColumnNames(sheetName string, trimSpace bool) ([]string, error)
  • func (f *File) SheetNames(sortAsc bool) []string
  • func (f *File) TableData(sheetName string, headerRowCount uint, trimSpace, umerge bool) ([]string, [][]string, error)
  • func (f *File) TableDataIndex(sheetIdx uint, headerRowCount uint, trimSpace, umerge bool) ([]string, [][]string, error)

Constants

const (
	TypePattern                = "pattern"
	StyleBackgroundColorFormat = `{"fill":{"type":"pattern","color":["%s"],"pattern":1}}`
)

Variables

var ErrExcelizeFileCannotBeNil = errors.New("excelize.File cannot be nil")

Functions

func ColumnsTop

func ColumnsTop(cols [][]string, trimSpace bool) []string

ColumnsTop converts a response from `excelize.File.GetCols()` to an `[]string` suitable for `Table.Columns`.

func GetCellValue

func GetCellValue(f *excelize.File, sheetName string, colIdx, rowIdx uint, opts ...excelize.Options) (string, error)

func SetRowValues

func SetRowValues(f *excelize.File, sheetName string, rowIndex uint, rowValues []any) error

func StyleBackgroundColorSimple

func StyleBackgroundColorSimple(hexRGBs []string) (*excelize.Style, error)

StyleBackgroundColorSimple returns a `*excelize.Style` given a slice of RGB colors. A `nil` value is returned if there are no hex values supplied.

Types

type File

type File struct {
	*excelize.File
}

func NewFile

func NewFile(filename string) (*File, error)

func ReadFile

func ReadFile(filename string) (*File, error)

func (*File) Close

func (f *File) Close() error

func (*File) SheetColumnNames

func (f *File) SheetColumnNames(sheetName string, trimSpace bool) ([]string, error)

func (*File) SheetNames

func (f *File) SheetNames(sortAsc bool) []string

func (*File) TableData

func (f *File) TableData(sheetName string, headerRowCount uint, trimSpace, umerge bool) ([]string, [][]string, error)

func (*File) TableDataIndex

func (f *File) TableDataIndex(sheetIdx uint, headerRowCount uint, trimSpace, umerge bool) ([]string, [][]string, error)