export

Documentation

Index

• Variables
• func NewFile(sheet string, header []string) *excelize.File
• func NewSheet(f *excelize.File, sheet string, header []string)
• func NewXlsxFile(sheetName string, header []string) (*xlsx.File, *xlsx.Sheet)
• func XlsxWriteValue(row *xlsx.Row, values []interface{})
• type ColumnNumber
  • func (c ColumnNumber) Sting() string

Variables

var ColumnLetter = [...]string{"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC"}

var HeaderStyle = &excelize.Style{
	Border: []excelize.Border{{
		Type:  "left",
		Color: "000000",
		Style: 1,
	},
		{
			Type:  "top",
			Color: "000000",
			Style: 1,
		},
		{
			Type:  "bottom",
			Color: "000000",
			Style: 1,
		},
		{
			Type:  "right",
			Color: "000000",
			Style: 1,
		}},
	Fill: excelize.Fill{
		Type:    "pattern",
		Pattern: 1,
		Color:   []string{"#bfbfbf"},
	},
	Font: &excelize.Font{Bold: true},
	Alignment: &excelize.Alignment{
		Horizontal: "center",
		Vertical:   "center",
	},
	Protection:   nil,
	NumFmt:       0,
	CustomNumFmt: nil,
	NegRed:       false,
}

var Style = &excelize.Style{
	Alignment: &excelize.Alignment{
		Horizontal: "center",
		Vertical:   "center",
	},
}

Functions

func NewFile

func NewFile(sheet string, header []string) *excelize.File

360 excel库文档宣称性能很强，实际性能很差，尤其合并单元格

func NewSheet

func NewSheet(f *excelize.File, sheet string, header []string)

func NewXlsxFile

func NewXlsxFile(sheetName string, header []string) (*xlsx.File, *xlsx.Sheet)

func XlsxWriteValue

func XlsxWriteValue(row *xlsx.Row, values []interface{})

Types

type ColumnNumber

type ColumnNumber int

const (
	A ColumnNumber = iota
	B
	C
	D
	E
	F
	G
	H
	I
	J
	K
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
	X
	Y
	Z
	AA
	AB
	AC
)

func (ColumnNumber) Sting

func (c ColumnNumber) Sting() string

只拓展到两位列ZZ