diff options
| author | Cooper de Nicola <cdenicol@stanford.edu> | 2022-08-24 18:34:29 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-08-25 09:34:29 +0800 |
| commit | 0e9378fec2ab4ba60ed284db4383df86555076d1 (patch) | |
| tree | 39e3f2eac3a4c135c52f25d740fdb9b20bd60f13 /excelize_test.go | |
| parent | cb8bca0e92cbec30db10c2a2863ef81fd98a6138 (diff) | |
This closes #1247, add new function `SetSheetCol` for set worksheet column values (#1320)
Signed-off-by: cdenicola <cooper.denicola@instabase.com>
Co-authored-by: cdenicola <cooper.denicola@instabase.com>
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 17 |
1 files changed, 17 insertions, 0 deletions
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) { |