excel

Documentation

Index

• Variables
• func MergeCell(sw *excelize.StreamWriter, startRowNum, endRowNum int, cells []string)
• func NewFile(sheet string, header []string) (*excelize.File, error)
• func NewSheet(f *excelize.File, sheet string, header []string) error
• func SetBodyRow(sw *excelize.StreamWriter, f *excelize.File, rowNum int, cellVal []any)
• func SetBodyRow2(sw *excelize.StreamWriter, f *excelize.File, rowNum int, cellVal []string, ...)
• func SetCellDropListStyle(sw *excelize.StreamWriter, f *excelize.File, hiddenSheetName string, ...)
• func SetHeaderRow(sw *excelize.StreamWriter, f *excelize.File, rowNum int, colWith float64, ...)
• func SetNoteRow(sw *excelize.StreamWriter, f *excelize.File, rowNum, maxCol int, ...) error
• 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 MergeCell

func MergeCell(sw *excelize.StreamWriter, startRowNum, endRowNum int, cells []string)

合并单元格 参数

sw, excel StreamWriter
startRowNum, 要合并开始的excel行号
endRowNum, 要合并结束的excel行号
cells, 要合并单元格的列("A","B","C")

func NewFile

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

func NewSheet

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

func SetBodyRow

func SetBodyRow(sw *excelize.StreamWriter, f *excelize.File, rowNum int, cellVal []any)

SetBodyRow

为excel stream设置行

参数

sw, excel StreamWriter
rowNum, 要设置的excel行号，行号是从1开始的，第一行行号为1
cellVal, 单元格内容

func SetBodyRow2

func SetBodyRow2(sw *excelize.StreamWriter, f *excelize.File, rowNum int, cellVal []string, errStyleLoc map[int]byte)

SetBodyRow2

为excel stream设置行

参数

sw, excel StreamWriter
rowNum, 要设置的excel行号，行号是从1开始的，第一行行号为1
cellVal, 单元格内容
errStyleLoc, 红色错误样式的单元格位置

func SetCellDropListStyle

func SetCellDropListStyle(sw *excelize.StreamWriter, f *excelize.File, hiddenSheetName string, dropListSize int, effectCellStart, effectCellEnd string)

SetCellDropListStyle 设置单元格下拉框选项样式，根据提供的下拉列表枚举值，作为单元格内容待候选值

	当下拉框列表太大时，无法直接采用AddDataValidation的形式添加
	这里通过将下拉枚举列表提前写入到隐藏的Sheet中，然后引用此隐藏Sheet再加载的方式实现
 @param sw excel streamWriter
 @param f excel file
 @param hiddenSheetName 存在此f中的隐藏Sheet
 @param dropListSize 下拉列表容量大小
 @param effectCellStart effectCellEnd 下拉框选项样式作用的单元格范围 起始位置 结束位置 例如 K2 K31

func SetHeaderRow

func SetHeaderRow(sw *excelize.StreamWriter, f *excelize.File, rowNum int, colWith float64, headers []string)

SetHeaderRow

为excel stream设置表头

参数

sw, excel StreamWriter
rowNum, 要作为表头的excel行号，行号是从1开始的，第一行行号为1
colWidth, 列宽, 为0时表示采用默认不设置
headers, 表头文案列表

func SetNoteRow

func SetNoteRow(sw *excelize.StreamWriter, f *excelize.File, rowNum, maxCol int, rowHeight float64, note string) error

SetNoteRow

为excel stream设置提醒行

参数

sw, excel StreamWriter
rowNum, 要作为提醒文本行的excel行号，行号是从1开始，第一行行号为1
maxCol, 提醒文本最多占用多少格
rowHeight, 行高
note, 提醒文案

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