finclip-app-manager/vendor/github.com/tealeg/xlsx/style.go

204 lines
4.4 KiB
Go
Raw Permalink Normal View History

2023-11-02 18:36:36 +08:00
package xlsx
import "strconv"
// Several popular font names that can be used to create fonts
const (
Helvetica = "Helvetica"
Baskerville = "Baskerville Old Face"
TimesNewRoman = "Times New Roman"
Bodoni = "Bodoni MT"
GillSans = "Gill Sans MT"
Courier = "Courier"
)
const (
RGB_Light_Green = "FFC6EFCE"
RGB_Dark_Green = "FF006100"
RGB_Light_Red = "FFFFC7CE"
RGB_Dark_Red = "FF9C0006"
RGB_White = "00000000"
RGB_Black = "FFFFFFFF"
)
const (
Solid_Cell_Fill = "solid"
)
// Style is a high level structure intended to provide user access to
// the contents of Style within an XLSX file.
type Style struct {
Border Border
Fill Fill
Font Font
ApplyBorder bool
ApplyFill bool
ApplyFont bool
ApplyAlignment bool
Alignment Alignment
NamedStyleIndex *int
}
// Return a new Style structure initialised with the default values.
func NewStyle() *Style {
return &Style{
Alignment: *DefaultAlignment(),
Border: *DefaultBorder(),
Fill: *DefaultFill(),
Font: *DefaultFont(),
}
}
// Generate the underlying XLSX style elements that correspond to the Style.
func (style *Style) makeXLSXStyleElements() (xFont xlsxFont, xFill xlsxFill, xBorder xlsxBorder, xCellXf xlsxXf) {
xFont = xlsxFont{}
xFill = xlsxFill{}
xBorder = xlsxBorder{}
xCellXf = xlsxXf{}
xFont.Sz.Val = strconv.Itoa(style.Font.Size)
xFont.Name.Val = style.Font.Name
xFont.Family.Val = strconv.Itoa(style.Font.Family)
xFont.Charset.Val = strconv.Itoa(style.Font.Charset)
xFont.Color.RGB = style.Font.Color
if style.Font.Bold {
xFont.B = &xlsxVal{}
} else {
xFont.B = nil
}
if style.Font.Italic {
xFont.I = &xlsxVal{}
} else {
xFont.I = nil
}
if style.Font.Underline {
xFont.U = &xlsxVal{}
} else {
xFont.U = nil
}
xPatternFill := xlsxPatternFill{}
xPatternFill.PatternType = style.Fill.PatternType
xPatternFill.FgColor.RGB = style.Fill.FgColor
xPatternFill.BgColor.RGB = style.Fill.BgColor
xFill.PatternFill = xPatternFill
xBorder.Left = xlsxLine{
Style: style.Border.Left,
Color: xlsxColor{RGB: style.Border.LeftColor},
}
xBorder.Right = xlsxLine{
Style: style.Border.Right,
Color: xlsxColor{RGB: style.Border.RightColor},
}
xBorder.Top = xlsxLine{
Style: style.Border.Top,
Color: xlsxColor{RGB: style.Border.TopColor},
}
xBorder.Bottom = xlsxLine{
Style: style.Border.Bottom,
Color: xlsxColor{RGB: style.Border.BottomColor},
}
xCellXf = makeXLSXCellElement()
xCellXf.ApplyBorder = style.ApplyBorder
xCellXf.ApplyFill = style.ApplyFill
xCellXf.ApplyFont = style.ApplyFont
xCellXf.ApplyAlignment = style.ApplyAlignment
if style.NamedStyleIndex != nil {
xCellXf.XfId = style.NamedStyleIndex
}
return
}
func makeXLSXCellElement() (xCellXf xlsxXf) {
xCellXf.NumFmtId = 0
return
}
// Border is a high level structure intended to provide user access to
// the contents of Border Style within an Sheet.
type Border struct {
Left string
LeftColor string
Right string
RightColor string
Top string
TopColor string
Bottom string
BottomColor string
}
func NewBorder(left, right, top, bottom string) *Border {
return &Border{
Left: left,
Right: right,
Top: top,
Bottom: bottom,
}
}
// Fill is a high level structure intended to provide user access to
// the contents of background and foreground color index within an Sheet.
type Fill struct {
PatternType string
BgColor string
FgColor string
}
func NewFill(patternType, fgColor, bgColor string) *Fill {
return &Fill{
PatternType: patternType,
FgColor: fgColor,
BgColor: bgColor,
}
}
type Font struct {
Size int
Name string
Family int
Charset int
Color string
Bold bool
Italic bool
Underline bool
}
func NewFont(size int, name string) *Font {
return &Font{Size: size, Name: name}
}
type Alignment struct {
Horizontal string
Indent int
ShrinkToFit bool
TextRotation int
Vertical string
WrapText bool
}
var defaultFontSize = 12
var defaultFontName = "Verdana"
func SetDefaultFont(size int, name string) {
defaultFontSize = size
defaultFontName = name
}
func DefaultFont() *Font {
return NewFont(defaultFontSize, defaultFontName)
}
func DefaultFill() *Fill {
return NewFill("none", "", "")
}
func DefaultBorder() *Border {
return NewBorder("none", "none", "none", "none")
}
func DefaultAlignment() *Alignment {
return &Alignment{
Horizontal: "general",
Vertical: "bottom",
}
}