StreamWriter couldn't set row style by RowOpt

[invzhi]

Description

Stream Writer couldn't set row style by RowOpt.

Steps to reproduce the issue:

f := excelize.NewFile()
w, _ := f.NewStreamWriter("Sheet1")

styleID, _ := f.NewStyle(&excelize.Style{
	Fill: excelize.Fill{Type: "pattern", Color: []string{"#FBBC04"}, Pattern: 1},
})

_ = w.SetRow("A1", []interface{}{"value1", "value2"}, excelize.RowOpts{StyleID: styleID})
_ = w.Flush()

_ = f.SaveAs("demo.xlsx")

Describe the results you received:

Describe the results you expected:

Output of go version:

go version go1.18.4 darwin/arm64

Excelize version or commit ID:

v2.6.1

[xuri]

Thanks for your issue. The stream writer won't apply or overwrite the style of each cell when you specify the row style, please specify the style for each cell as you need like this:

w.SetRow("A1", []interface{}{
    excelize.Cell{StyleID: styleID, Value: "value1"},
    excelize.Cell{StyleID: styleID, Value: "value2"},
})

[invzhi]

Thanks for your quick response. I would like to open a pull request to fix this issue.

I have a question about the expected behavior.

When I specify the style like this:

w.SetRow("A1", []interface{}{excelize.Cell{StyleID: 0, Value: "value1"}}, excelize.RowOpts{StyleID: styleID})

The style id of A1 should be:

1. overridden by 0
2. still use styleID in excelize.RowOpts?

My understanding is that the first is the expected behavior, which the developers could unset the cell style.

[xuri]

Yep, the cell style should be overridden by 0 in this case, the cell style priority is hight than the rows.