From 0e9378fec2ab4ba60ed284db4383df86555076d1 Mon Sep 17 00:00:00 2001 From: Cooper de Nicola Date: Wed, 24 Aug 2022 18:34:29 -0700 Subject: This closes #1247, add new function `SetSheetCol` for set worksheet column values (#1320) Signed-off-by: cdenicola Co-authored-by: cdenicola --- excelize_test.go | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'excelize_test.go') diff --git a/excelize_test.go b/excelize_test.go index f1b9903..5db658a 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -1123,6 +1123,23 @@ func TestSharedStrings(t *testing.T) { assert.NoError(t, f.Close()) } +func TestSetSheetCol(t *testing.T) { + f, err := OpenFile(filepath.Join("test", "Book1.xlsx")) + if !assert.NoError(t, err) { + t.FailNow() + } + + assert.NoError(t, f.SetSheetCol("Sheet1", "B27", &[]interface{}{"cell", nil, int32(42), float64(42), time.Now().UTC()})) + + assert.EqualError(t, f.SetSheetCol("Sheet1", "", &[]interface{}{"cell", nil, 2}), + newCellNameToCoordinatesError("", newInvalidCellNameError("")).Error()) + + assert.EqualError(t, f.SetSheetCol("Sheet1", "B27", []interface{}{}), ErrParameterInvalid.Error()) + assert.EqualError(t, f.SetSheetCol("Sheet1", "B27", &f), ErrParameterInvalid.Error()) + assert.NoError(t, f.SaveAs(filepath.Join("test", "TestSetSheetCol.xlsx"))) + assert.NoError(t, f.Close()) +} + func TestSetSheetRow(t *testing.T) { f, err := OpenFile(filepath.Join("test", "Book1.xlsx")) if !assert.NoError(t, err) { -- cgit v1.2.1