From 4a029f7e3602ac48b6fbf410b86adac2af64983a Mon Sep 17 00:00:00 2001 From: Thomas Charbonnel Date: Thu, 4 Aug 2022 16:50:33 +0800 Subject: This closes #1299 skip write nil values in SetRow (#1301) Co-authored-by: Thomas Charbonnel --- stream_test.go | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'stream_test.go') diff --git a/stream_test.go b/stream_test.go index 6843e20..8f6a5b4 100644 --- a/stream_test.go +++ b/stream_test.go @@ -209,6 +209,17 @@ func TestSetRow(t *testing.T) { assert.EqualError(t, streamWriter.SetRow("A", []interface{}{}), newCellNameToCoordinatesError("A", newInvalidCellNameError("A")).Error()) } +func TestSetRowNilValues(t *testing.T) { + file := NewFile() + streamWriter, err := file.NewStreamWriter("Sheet1") + assert.NoError(t, err) + streamWriter.SetRow("A1", []interface{}{nil, nil, Cell{Value: "foo"}}) + streamWriter.Flush() + ws, err := file.workSheetReader("Sheet1") + assert.NoError(t, err) + assert.NotEqual(t, ws.SheetData.Row[0].C[0].XMLName.Local, "c") +} + func TestSetCellValFunc(t *testing.T) { f := NewFile() sw, err := f.NewStreamWriter("Sheet1") -- cgit v1.2.1