excelutil

package

v0.0.0-...-e311a6d Latest Latest Go to latest Published: Apr 23, 2024 License: Apache-2.0 Imports: 4 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

func GetDefaultDataStyle(isBold bool, alignment xlsx.Alignment) *xlsx.Style

func GetDefaultTitleStyle(isBold bool, alignment xlsx.Alignment) *xlsx.Style

type Aliment int

const (
	AlimentLeft Aliment = iota + 1
	AlimentRight
	AimentCenter
)

func (a Aliment) String() string

type Cell struct {
	// contains filtered or unexported fields
}

func NewCell(content string) *Cell

func (c *Cell) Bold(isBold bool) *Cell

func (c *Cell) HorizontalAlignment(alignment Aliment) *Cell

func (c *Cell) WrapText(wrapText bool) *Cell

type File interface {
	AddSheet(name string, sheetDir SheetDir, titleStyle *xlsx.Style) (Sheet, error)
	ToBytes() ([]byte, error)
}

func NewExcelFile(
	fileName string,
) (File, error)

type Sheet interface {
	SetWidths(widths []uint32)
	AddTitle(titles []*Title)
	AddEntry(cells []*Cell, customStyle *xlsx.Style)
}

type SheetDir int

const (
	SheetDirTB SheetDir = iota + 1 // top-bottom direction
	SheetDirLR                     // left-right direction
)

type Title struct {
	// contains filtered or unexported fields
}

func NewCustomTitle(title string) *Title

func (t *Title) Bold(isBold bool) *Title

func (t *Title) HorizontalAlignment(alignment Aliment) *Title

func (t *Title) MergeCell(mergeCellNum uint) *Title

func (t *Title) WithBackgroundFill(fill *xlsx.Fill) *Title

func (t *Title) WrapText(wrapText bool) *Title

type XlsxFile struct {
	File     *xlsx.File
	FileName string
}

func (f *XlsxFile) AddSheet(
	name string, sheetDir SheetDir, titleStyle *xlsx.Style,
) (Sheet, error)

func (f *XlsxFile) ToBytes() ([]byte, error)

type XlsxSheet struct {
	Sheet     *xlsx.Sheet
	SheetName string
	Direction SheetDir

	TitleStyle *xlsx.Style

	ColCount uint32
	RowCount uint32
}

func (s *XlsxSheet) AddEntry(cells []*Cell, customStyle *xlsx.Style)

func (s *XlsxSheet) AddTitle(titles []*Title)

func (s *XlsxSheet) SetWidths(widths []uint32)