excelV2

package
v1.54.21 Latest Latest
Warning

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

 Go to latest Published: Jan 4, 2026 License: Apache-2.0 Imports: 14 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var (
	ErrRead              = errors.New("读取文件失败")
	ErrFilenameRequired  = errors.New("文件名不能为空")
	ErrSheetNameRequired = errors.New("工作表名称不能为空")
	ErrCreateSheet       = errors.New("创建工作表失败")
	ErrSheetNotFound     = errors.New("工作表不存在")
	ErrSetFont           = errors.New("设置字体失败")
	ErrSetCell           = errors.New("设置单元格失败")
	ErrSetSheet          = errors.New("设置工作表失败")
	ErrWriteCellFormula  = errors.New("写入单元格失败（公式）")
	ErrWriteCellInt      = errors.New("写入单元格失败（整数）")
	ErrWriteCellFloat    = errors.New("写入单元格失败（浮点）")
	ErrWriteCellBool     = errors.New("写入单元格失败（布尔）")
	ErrWriteCellTime     = errors.New("写入单元格失败（时间）")
	ErrWriteCellAny      = errors.New("写入单元格失败（常规）")
	ErrSave              = errors.New("保存文件失败")
	ErrDownload          = errors.New("下载文件失败")
	ErrColumnNumber      = errors.New("错误的列索引")
	ErrOpen              = errors.New("打开文件失败")
	ErrClose             = errors.New("关闭文件失败")
	ErrInvalidStruct     = errors.New("无效的结构体")
)
View Source 
var APP struct {
	Writer     Writer
	WriterAttr struct {
		Filename  AttrWriterFilename
		SheetName AttrWriterSheetName
		Cells     AttrWriterCells
		Rows      AttrWriterRows
	}
	Row     Row
	RowAttr struct {
		Cells  AttrCells
		Number AttrNumber
	}
	Cell     Cell
	CellAttr struct {
		Content       AttrCellContent
		ContentType   AttrCellContentType
		Coordinate    AttrCellCoordinate
		FontRGB       AttrCellFontRGB
		PatternRGB    AttrCellPatternRGB
		FontBold      AttrCellFontBold
		FontItalic    AttrCellFontItalic
		FontSize      AttrCellFontSize
		BorderRGB     AttrCellBorderRGB
		BorderStyle   AttrCellBorderStyle
		DiagonalRGB   AttrCellDiagonalRGB
		DiagonalStyle AttrCellDiagonalStyle
		WrapText      AttrCellWrapText
	}
	Reader     Reader
	ReaderAttr struct {
		Filename    AttrReaderFilename
		SheetName   AttrReaderSheetName
		OriginalRow AttrReaderOriginalRow
		FinishedRow AttrReaderFinishedRow
		OriginalCol AttrReaderOriginalCol
		FinishedCol AttrReaderFinishedCol
	}
}

Functions

func ColumnNumberToText added in v1.53.3 

func ColumnNumberToText(columnNumber int) (string, error)

ColumnNumberToText 列索引转文字

func ColumnTextToNumber added in v1.53.3 

func ColumnTextToNumber(columnText string) int

ColumnTextToNumber 列文字转索引

Types

type AttrCellBorderRGB added in v1.53.3 

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

func (AttrCellBorderRGB) Register added in v1.53.3 

func (my AttrCellBorderRGB) Register(cell *Cell)

func (AttrCellBorderRGB) Set added in v1.53.3 

func (AttrCellBorderRGB) Set(top, bottom, left, right string) CellAttributer

type AttrCellBorderStyle added in v1.53.3 

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

func (AttrCellBorderStyle) Register added in v1.53.3 

func (my AttrCellBorderStyle) Register(cell *Cell)

func (AttrCellBorderStyle) Set added in v1.53.3 

func (AttrCellBorderStyle) Set(top, bottom, left, right int) CellAttributer

type AttrCellContent added in v1.53.3 

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

func (AttrCellContent) Register added in v1.53.3 

func (my AttrCellContent) Register(cell *Cell)

func (AttrCellContent) Set added in v1.53.3 

func (AttrCellContent) Set(val any) CellAttributer

type AttrCellContentType added in v1.53.3 

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

func (AttrCellContentType) Register added in v1.53.3 

func (my AttrCellContentType) Register(cell *Cell)

func (AttrCellContentType) Set added in v1.53.3 

func (AttrCellContentType) Set(val CellContentType) CellAttributer

type AttrCellCoordinate added in v1.53.3 

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

func (AttrCellCoordinate) Register added in v1.53.3 

func (my AttrCellCoordinate) Register(cell *Cell)

func (AttrCellCoordinate) Set added in v1.53.3 

func (AttrCellCoordinate) Set(val string) CellAttributer

type AttrCellDiagonalRGB added in v1.53.3 

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

func (AttrCellDiagonalRGB) Register added in v1.53.3 

func (my AttrCellDiagonalRGB) Register(cell *Cell)

func (AttrCellDiagonalRGB) Set added in v1.53.3 

func (AttrCellDiagonalRGB) Set(up, down string) CellAttributer

type AttrCellDiagonalStyle added in v1.53.3 

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

func (AttrCellDiagonalStyle) Register added in v1.53.3 

func (my AttrCellDiagonalStyle) Register(cell *Cell)

func (AttrCellDiagonalStyle) Set added in v1.53.3 

func (AttrCellDiagonalStyle) Set(up, down int) CellAttributer

type AttrCellFontBold added in v1.53.3 

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

func (AttrCellFontBold) Register added in v1.53.3 

func (my AttrCellFontBold) Register(cell *Cell)

func (AttrCellFontBold) Set added in v1.53.3 

func (AttrCellFontBold) Set(val bool) CellAttributer

func (AttrCellFontBold) SetFalse added in v1.53.3 

func (AttrCellFontBold) SetFalse() CellAttributer

func (AttrCellFontBold) SetTrue added in v1.53.3 

func (AttrCellFontBold) SetTrue() CellAttributer

type AttrCellFontItalic added in v1.53.3 

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

func (AttrCellFontItalic) Register added in v1.53.3 

func (my AttrCellFontItalic) Register(cell *Cell)

func (AttrCellFontItalic) Set added in v1.53.3 

func (AttrCellFontItalic) Set(val bool) CellAttributer

func (AttrCellFontItalic) SetFalse added in v1.53.3 

func (AttrCellFontItalic) SetFalse() CellAttributer

func (AttrCellFontItalic) SetTrue added in v1.53.3 

func (AttrCellFontItalic) SetTrue() CellAttributer

type AttrCellFontRGB added in v1.53.3 

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

func (AttrCellFontRGB) Register added in v1.53.3 

func (my AttrCellFontRGB) Register(cell *Cell)

func (AttrCellFontRGB) Set added in v1.53.3 

func (AttrCellFontRGB) Set(val string) CellAttributer

type AttrCellFontSize added in v1.53.3 

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

func (AttrCellFontSize) Register added in v1.53.3 

func (my AttrCellFontSize) Register(cell *Cell)

func (AttrCellFontSize) Set added in v1.53.3 

func (AttrCellFontSize) Set(val float64) CellAttributer

type AttrCellPatternRGB added in v1.53.3 

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

func (AttrCellPatternRGB) Register added in v1.53.3 

func (my AttrCellPatternRGB) Register(cell *Cell)

func (AttrCellPatternRGB) Set added in v1.53.3 

func (AttrCellPatternRGB) Set(val string) CellAttributer

type AttrCellWrapText added in v1.53.3 

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

func (AttrCellWrapText) Register added in v1.53.3 

func (my AttrCellWrapText) Register(cell *Cell)

func (AttrCellWrapText) Set added in v1.53.3 

func (AttrCellWrapText) Set(val bool) CellAttributer

func (AttrCellWrapText) SetFalse added in v1.53.3 

func (AttrCellWrapText) SetFalse() CellAttributer

func (AttrCellWrapText) SetTrue added in v1.53.3 

func (AttrCellWrapText) SetTrue() CellAttributer

type AttrCells added in v1.53.3 

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

func (AttrCells) Register added in v1.53.3 

func (my AttrCells) Register(row *Row)

func (AttrCells) Set added in v1.53.3 

func (AttrCells) Set(cells ...*Cell) RowAttributer

type AttrNumber added in v1.53.3 

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

func (AttrNumber) Register added in v1.53.3 

func (my AttrNumber) Register(row *Row)

func (AttrNumber) Set added in v1.53.3 

func (AttrNumber) Set(number uint64) RowAttributer

type AttrReaderFilename added in v1.53.3 

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

func (AttrReaderFilename) Register added in v1.53.3 

func (my AttrReaderFilename) Register(reader *Reader)

func (AttrReaderFilename) Set added in v1.53.3 

func (AttrReaderFilename) Set(val string) ReaderAttributer

type AttrReaderFinishedCol added in v1.53.3 

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

func (AttrReaderFinishedCol) Register added in v1.53.3 

func (my AttrReaderFinishedCol) Register(reader *Reader)

func (AttrReaderFinishedCol) Set added in v1.53.3 

func (AttrReaderFinishedCol) Set(val uint) ReaderAttributer

type AttrReaderFinishedRow added in v1.53.3 

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

func (AttrReaderFinishedRow) Register added in v1.53.3 

func (my AttrReaderFinishedRow) Register(reader *Reader)

func (AttrReaderFinishedRow) Set added in v1.53.3 

func (AttrReaderFinishedRow) Set(val uint) ReaderAttributer

type AttrReaderOriginalCol added in v1.53.3 

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

func (AttrReaderOriginalCol) Register added in v1.53.3 

func (my AttrReaderOriginalCol) Register(reader *Reader)

func (AttrReaderOriginalCol) Set added in v1.53.3 

func (AttrReaderOriginalCol) Set(val uint) ReaderAttributer

type AttrReaderOriginalRow added in v1.53.3 

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

func (AttrReaderOriginalRow) Register added in v1.53.3 

func (my AttrReaderOriginalRow) Register(reader *Reader)

func (AttrReaderOriginalRow) Set added in v1.53.3 

func (AttrReaderOriginalRow) Set(val uint) ReaderAttributer

type AttrReaderSheetName added in v1.53.3 

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

func (AttrReaderSheetName) Register added in v1.53.3 

func (my AttrReaderSheetName) Register(reader *Reader)

func (AttrReaderSheetName) Set added in v1.53.3 

func (AttrReaderSheetName) Set(val string) ReaderAttributer

type AttrWriterCells added in v1.53.3 

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

func (AttrWriterCells) Register added in v1.53.3 

func (my AttrWriterCells) Register(writer *Writer)

func (AttrWriterCells) Set added in v1.53.3 

func (AttrWriterCells) Set(vals ...*Cell) WriterAttributer

type AttrWriterFilename added in v1.53.3 

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

func (AttrWriterFilename) Register added in v1.53.3 

func (my AttrWriterFilename) Register(writer *Writer)

func (AttrWriterFilename) Set added in v1.53.3 

func (AttrWriterFilename) Set(val string) WriterAttributer

type AttrWriterRows added in v1.53.3 

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

func (AttrWriterRows) Append added in v1.53.3 

func (AttrWriterRows) Append(offset int, vals ...*Row) WriterAttributer

func (AttrWriterRows) Register added in v1.53.3 

func (my AttrWriterRows) Register(writer *Writer)

func (AttrWriterRows) Set added in v1.53.3 

func (AttrWriterRows) Set(vals ...*Row) WriterAttributer

type AttrWriterSheetName added in v1.53.3 

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

func (AttrWriterSheetName) Register added in v1.53.3 

func (my AttrWriterSheetName) Register(writer *Writer)

func (AttrWriterSheetName) Set added in v1.53.3 

func (AttrWriterSheetName) Set(val string) WriterAttributer

type Cell added in v1.53.3 

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

func (*Cell) GetBorder added in v1.53.3 

func (my *Cell) GetBorder() anyArrayV2.AnyArray[border]

func (*Cell) GetContent added in v1.53.3 

func (my *Cell) GetContent() any

func (*Cell) GetContentType added in v1.53.3 

func (my *Cell) GetContentType() CellContentType

func (*Cell) GetCoordinate added in v1.53.3 

func (my *Cell) GetCoordinate() string

func (*Cell) GetFontBold added in v1.53.3 

func (my *Cell) GetFontBold() bool

func (*Cell) GetFontFamily added in v1.53.3 

func (my *Cell) GetFontFamily() string

func (*Cell) GetFontItalic added in v1.53.3 

func (my *Cell) GetFontItalic() bool

func (*Cell) GetFontRGB added in v1.53.3 

func (my *Cell) GetFontRGB() string

func (*Cell) GetFontSize added in v1.53.3 

func (my *Cell) GetFontSize() float64

func (*Cell) GetPatternRGB added in v1.53.3 

func (my *Cell) GetPatternRGB() string

func (*Cell) GetWrapText added in v1.53.3 

func (my *Cell) GetWrapText() bool

func (*Cell) New added in v1.53.3 

func (*Cell) New(attrs ...CellAttributer) *Cell

func (*Cell) NewAny added in v1.53.3 

func (*Cell) NewAny(content any, attrs ...CellAttributer) *Cell

func (*Cell) NewBool added in v1.53.3 

func (*Cell) NewBool(content any, attrs ...CellAttributer) *Cell

func (*Cell) NewFloat added in v1.53.3 

func (*Cell) NewFloat(content any, attrs ...CellAttributer) *Cell

func (*Cell) NewFormula added in v1.53.3 

func (*Cell) NewFormula(content any, attrs ...CellAttributer) *Cell

func (*Cell) NewInt added in v1.53.3 

func (*Cell) NewInt(content any, attrs ...CellAttributer) *Cell

func (*Cell) NewTime added in v1.53.3 

func (*Cell) NewTime(content any, attrs ...CellAttributer) *Cell

func (*Cell) SetAttrs added in v1.53.3 

func (my *Cell) SetAttrs(attrs ...CellAttributer) *Cell

type CellAttributer added in v1.53.3 

type CellAttributer interface{ Register(cell *Cell) }

type CellContentType added in v1.53.3 

type CellContentType string
const (
	CellContentTypeAny     CellContentType = "any"
	CellContentTypeFormula CellContentType = "formula"
	CellContentTypeInt     CellContentType = "int"
	CellContentTypeFloat   CellContentType = "float64"
	CellContentTypeBool    CellContentType = "bool"
	CellContentTypeTime    CellContentType = "time"
)

type Reader 

type Reader struct {
	Error error
	// contains filtered or unexported fields
}

func (*Reader) GetMap added in v1.53.3 

func (my *Reader) GetMap() map[string]string

func (*Reader) GetMaps added in v1.53.3 

func (my *Reader) GetMaps() []map[string]string

func (*Reader) GetOriginalData added in v1.53.3 

func (my *Reader) GetOriginalData() [][]string

func (*Reader) New 

func (*Reader) New(attrs ...ReaderAttributer) *Reader

func (*Reader) SetAttrs added in v1.53.3 

func (my *Reader) SetAttrs(attrs ...ReaderAttributer) *Reader

func (*Reader) ToStruct added in v1.53.3 

func (my *Reader) ToStruct(title []string, ret any)

type ReaderAttributer added in v1.53.3 

type ReaderAttributer interface{ Register(reader *Reader) }

type Row added in v1.53.3 

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

func (*Row) GetCells added in v1.53.3 

func (my *Row) GetCells() []*Cell

func (*Row) GetNumber added in v1.53.3 

func (my *Row) GetNumber() uint64

func (*Row) New added in v1.53.3 

func (*Row) New(attrs ...RowAttributer) *Row

func (*Row) SetAttrs added in v1.53.3 

func (my *Row) SetAttrs(attrs ...RowAttributer) *Row

type RowAttributer added in v1.53.3 

type RowAttributer interface{ Register(row *Row) }

type Writer added in v1.53.3 

type Writer struct {
	Error error
	// contains filtered or unexported fields
}

func (*Writer) CreateSheet added in v1.53.3 

func (my *Writer) CreateSheet(sheetName string) *Writer

CreateSheet 创建工作表

func (*Writer) Download added in v1.53.3 

func (my *Writer) Download(w http.ResponseWriter) *Writer

Download 下载文件

func (*Writer) FromStruct added in v1.53.3 

func (my *Writer) FromStruct(data any, title []string, offset int, attrs ...CellAttributer) *Writer

func (*Writer) GetFilename added in v1.53.3 

func (my *Writer) GetFilename() string

func (*Writer) GetSheetName added in v1.53.3 

func (my *Writer) GetSheetName() string

func (*Writer) New added in v1.53.3 

func (*Writer) New(attrs ...WriterAttributer) *Writer

func (*Writer) Save added in v1.53.3 

func (my *Writer) Save() *Writer

Save 保存文件

func (*Writer) SetAttrs added in v1.53.3 

func (my *Writer) SetAttrs(attrs ...WriterAttributer) *Writer

type WriterAttributer added in v1.53.3 

type WriterAttributer interface{ Register(writer *Writer) }

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.