From b25ec6e9d3adfd329a1808ea70354deb38f94225 Mon Sep 17 00:00:00 2001 From: dvelderp Date: Thu, 25 Jan 2018 18:06:40 +0100 Subject: xlsx.SetCellValue() now supports bool value --- excelize_test.go | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'excelize_test.go') diff --git a/excelize_test.go b/excelize_test.go index a4dc287..c7fb5de 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -81,6 +81,21 @@ func TestOpenFile(t *testing.T) { xlsx.SetCellValue("Sheet2", "F14", uint32(1<<32-1)) xlsx.SetCellValue("Sheet2", "F15", uint64(1<<32-1)) xlsx.SetCellValue("Sheet2", "F16", true) + // Test boolean write + booltest := []struct { + value bool + expected string + }{ + {false, "0"}, + {true, "1"}, + } + for _, test := range booltest { + xlsx.SetCellValue("Sheet2", "F16", test.value) + value := xlsx.GetCellValue("Sheet2", "F16") + if value != test.expected { + t.Errorf(`Expecting result of xlsx.SetCellValue("Sheet2", "F16", %v) to be %v (false), got: %s `, test.value, test.expected, value) + } + } xlsx.SetCellValue("Sheet2", "G2", nil) xlsx.SetCellValue("Sheet2", "G4", time.Now()) // 02:46:40 -- cgit v1.2.1