From a55f354eb3d0c6c1b9a543ff8ff98227aa6063a6 Mon Sep 17 00:00:00 2001 From: xuri Date: Tue, 17 Aug 2021 00:01:44 +0800 Subject: This closes #989, closes #990 New API: `SetRowStyle` support for set style for the rows Update documentation for the `GetRows`, `SetCellStyle` and `SetColStyle` --- rows_test.go | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'rows_test.go') diff --git a/rows_test.go b/rows_test.go index 7682469..a54e755 100644 --- a/rows_test.go +++ b/rows_test.go @@ -889,6 +889,18 @@ func TestCheckRow(t *testing.T) { assert.EqualError(t, f.SetCellValue("Sheet1", "A1", false), `cannot convert cell "-" to coordinates: invalid cell name "-"`) } +func TestSetRowStyle(t *testing.T) { + f := NewFile() + styleID, err := f.NewStyle(`{"fill":{"type":"pattern","color":["#E0EBF5"],"pattern":1}}`) + assert.NoError(t, err) + assert.EqualError(t, f.SetRowStyle("Sheet1", 10, -1, styleID), newInvalidRowNumberError(-1).Error()) + assert.EqualError(t, f.SetRowStyle("Sheet1", 1, TotalRows+1, styleID), ErrMaxRows.Error()) + assert.EqualError(t, f.SetRowStyle("Sheet1", 1, 1, -1), newInvalidStyleID(-1).Error()) + assert.EqualError(t, f.SetRowStyle("SheetN", 1, 1, styleID), "sheet SheetN is not exist") + assert.NoError(t, f.SetRowStyle("Sheet1", 10, 1, styleID)) + assert.NoError(t, f.SaveAs(filepath.Join("test", "TestSetRowStyle.xlsx"))) +} + func TestNumberFormats(t *testing.T) { f, err := OpenFile(filepath.Join("test", "Book1.xlsx")) if !assert.NoError(t, err) { -- cgit v1.2.1