excel

package

v1.0.1 Latest Latest Go to latest Published: Mar 16, 2025 License: MIT Imports: 12 Imported by: 0

Details

This section is empty.

This section is empty.

func ApplyStyleHeaders(file *excelize.File, sheetName string, headers TableHeaders) error

func DeleteDefaultSheet(file *excelize.File) error

func ExportEntitiesToSpreadsheet(filename string, exporters ...ExporterInterface) error

func ExportEntityToSpreadsheet[T any](file *excelize.File, sheetName string, entity T, provider func() ([]any, error)) error

func GetCellNameByIndices(column int, row int) (string, error)

func GetHeaderCellNameByIndex(column int) (string, error)

func GetStyleId(f *excelize.File, style *excelize.Style) (int, error)

func ImportEntitiesFromSpreadsheet(path string, importers ...Importer) error

func ImportFromSpreadsheet(filepath string, importer Importer) error

func LoadDataStyle(file *excelize.File) (int, error)

func LoadHeadersStyle(file *excelize.File) (int, error)

func SerializeNestedField(fieldInfo reflect.StructField, fieldValue reflect.Value) (*string, error)

func WriteData(file *excelize.File, filename string) error

type Exporter[T any] struct {
	SheetName string
	Entity    T
	Provider  func() ([]*T, error)
}

func (e Exporter[T]) GetEntity() any

func (e Exporter[T]) GetProvider() func() ([]any, error)

func (e Exporter[T]) GetSheetName() string

type ExporterInterface interface {
	GetSheetName() string
	GetEntity() any
	GetProvider() func() ([]any, error)
}

type Importer struct {
	SheetName       string
	Loader          func(rowIndex int, row []string) error
	StartFromRowIdx int
}

type TableHeaders struct {
	Headers              []string
	IgnoredFieldsIndexes []int
}

func ExportHeaders(entity any) (TableHeaders, error)

func WriteHeaders(sheetName string, entity any, file *excelize.File) (TableHeaders, error)