Style

Alignment directly maps the alignment settings of the cells.

type Alignment struct {
    Horizontal      string `json:"horizontal"`
    Indent          int    `json:"indent"`
    JustifyLastLine bool   `json:"justify_last_line"`
    ReadingOrder    uint64 `json:"reading_order"`
    RelativeIndent  int    `json:"relative_indent"`
    ShrinkToFit     bool   `json:"shrink_to_fit"`
    TextRotation    int    `json:"text_rotation"`
    Vertical        string `json:"vertical"`
    WrapText        bool   `json:"wrap_text"`
}

Border directly maps the border settings of the cells.

type Border struct {
    Type  string `json:"type"`
    Color string `json:"color"`
    Style int    `json:"style"`
}

Font directly maps the font settings of the fonts.

type Font struct {
    Bold      bool    `json:"bold"`
    Italic    bool    `json:"italic"`
    Underline string  `json:"underline"`
    Family    string  `json:"family"`
    Size      float64 `json:"size"`
    Strike    bool    `json:"strike"`
    Color     string  `json:"color"`
}

Fill directly maps the fill settings of the cells.

type Fill struct {
    Type    string   `json:"type"`
    Pattern int      `json:"pattern"`
    Color   []string `json:"color"`
    Shading int      `json:"shading"`
}

Protection directly maps the protection settings of the cells.

type Protection struct {
    Hidden bool `json:"hidden"`
    Locked bool `json:"locked"`
}

Style directly maps the style settings of the cells.

type Style struct {
    Border        []Border    `json:"border"`
    Fill          Fill        `json:"fill"`
    Font          *Font       `json:"font"`
    Alignment     *Alignment  `json:"alignment"`
    Protection    *Protection `json:"protection"`
    NumFmt        int         `json:"number_format"`
    DecimalPlaces int         `json:"decimal_places"`
    CustomNumFmt  *string     `json:"custom_number_format"`
    Lang          string      `json:"lang"`
    NegRed        bool        `json:"negred"`
}

Create style

func (f *File) NewStyle(style interface{}) (int, error)

NewStyle provides a function to create the style for cells by given JSON string or structure pointer. Note that the color field uses RGB color code.

Border

The following shows the border styles type sorted by excelize index number:

Index	Style	Line	Preview
0	None	0
1	Continuous	1
2	Continuous	2
3	Dash	1
4	Dot	1
5	Continuous	3
6	Double	3
7	Continuous	0
8	Dash	2
9	Dash Dot	1
10	Dash Dot	2
11	Dash Dot Dot	1
12	Dash Dot Dot	2
13	SlantDash Dot	2

The following shows the borders in the order shown in the Excel dialog:

Index	Preview	Index	Preview
0		12
7		13
4		10
11		8
9		2
3		5
1		6

Color fill

The following shows the shading styles sorted by excelize index number:

Pattern fill

The following shows the pattern styles sorted by excelize index number:

Index	Style	Index	Style
0	None	10
1		11
2		12
3		13
4		14
5		15
6		16
7		17
8		18
9

Align

Horizontal alignment

The following type of horizontal alignment in cells:

Vertical alignment

The following type of vertical alignment in cells:

Font underline

The following type of font underline style:

Number format

Excel's built-in all languages formats (the number_format parameter) are shown in the following table:

Traditional Chinese number format

Number format code in zh-tw language:

Simplified Chinese number format

Number format code in zh-cn language:

Unicode Traditional Chinese number format

Number format code with unicode values provided for language glyphs where they occur in zh-tw language:

Unicode Simplified Chinese number format

Number format code with unicode values provided for language glyphs where they occur in zh-cn language:

Japanese number format

Number format code in ja-jp language:

Korean number format

Number format code in ko-kr language:

Unicode Japanese number format

Number format code with unicode values provided for language glyphs where they occur in ja-jp language:

Unicode Korean number format

Number format code with unicode values provided for language glyphs where they occur in ko-kr language:

Thai language number format

Number format code in th-th language:

Unicode Thai language number format

Number format code with unicode values provided for language glyphs where they occur in th-th language:

Currency format

Excelize built-in currency formats are shown in the following table, only support these types in the following table (Index number is used only for markup and is not used inside an Excel file and you can't get formatted value by the function GetCellValue) currently:

Excelize support set custom number format for cell. For example, set number as date type in Uruguay (Spanish) format for Sheet1!A6:

f := excelize.NewFile()
f.SetCellValue("Sheet1", "A6", 42920.5)
exp := "[$-380A]dddd\\,\\ dd\" de \"mmmm\" de \"yyyy;@"
style, err := f.NewStyle(&excelize.Style{CustomNumFmt: &exp})
err = f.SetCellStyle("Sheet1", "A6", "A6", style)

Cell Sheet1!A6 in the Excel Application: martes, 04 de Julio de 2017

Set column style

func (f *File) SetColStyle(sheet, columns string, styleID int) error

SetColStyle provides a function to set style of columns by given worksheet name, columns range and style ID. Note that this will overwrite the existing styles for the columns, it won't append or merge style with existing styles.

For example set style of column H on Sheet1:

err = f.SetColStyle("Sheet1", "H", style)

Set style of columns C:F on Sheet1:

err = f.SetColStyle("Sheet1", "C:F", style)

Set row style

SetRowStyle provides a function to set the style of rows by given worksheet name, row range, and style ID. Note that this will overwrite the existing styles for the rows, it won't append or merge style with existing styles.

For example set style of row 1 on Sheet1:

err = f.SetRowStyle("Sheet1", 1, 1, styleID)

Set style of rows 1 to 10 on Sheet1:

err = f.SetRowStyle("Sheet1", 1, 10, styleID)

Set default font

func (f *File) SetDefaultFont(fontName string)

SetDefaultFont changes the default font in the workbook.

Get default font

func (f *File) GetDefaultFont() string

GetDefaultFont provides the default font name currently set in the workbook. The spreadsheet generated by excelize default font is Calibri.