From 266d2c36e58ad1a53286ab2c01a2d41e3af883c7 Mon Sep 17 00:00:00 2001 From: Ri Xu Date: Tue, 25 Apr 2017 18:43:10 +0800 Subject: - Font bold, italic and underline style support. Relate issue #45; - Function `GetRows()` doc updated, relate issue #43; - go test and embed template updated --- excelize_test.go | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) (limited to 'excelize_test.go') diff --git a/excelize_test.go b/excelize_test.go index 6d47a72..1b23dca 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -361,6 +361,37 @@ func TestSetCellStyleFill(t *testing.T) { } } +func TestSetCellStyleFont(t *testing.T) { + xlsx, err := OpenFile("./test/Workbook_2.xlsx") + if err != nil { + t.Log(err) + } + err = xlsx.SetCellStyle("Sheet2", "A1", "A1", `{"font":{"bold":true,"italic":true,"family":"Berlin Sans FB Demi","size":36,"color":"#777777","underline":"single"}}`) + if err != nil { + t.Log(err) + } + err = xlsx.SetCellStyle("Sheet2", "A2", "A2", `{"font":{"italic":true,"underline":"double"}}`) + if err != nil { + t.Log(err) + } + err = xlsx.SetCellStyle("Sheet2", "A3", "A3", `{"font":{"bold":true}}`) + if err != nil { + t.Log(err) + } + err = xlsx.SetCellStyle("Sheet2", "A4", "A4", `{"font":{"bold":true,"family":"","size":0,"color":"","underline":""}}`) + if err != nil { + t.Log(err) + } + err = xlsx.SetCellStyle("Sheet2", "A5", "A5", `{"font":{"color":"#777777"}}`) + if err != nil { + t.Log(err) + } + err = xlsx.Save() + if err != nil { + t.Log(err) + } +} + func TestSetDeleteSheet(t *testing.T) { xlsx, err := OpenFile("./test/Workbook_3.xlsx") if err != nil { -- cgit v1.2.1