How to freeze the top row?

[aphsa]

How to freeze the top row? I tried various combinations of this and did not work

err := f.SetPanes("Sheet1", &excelize.Panes{
    Freeze:      true,
    YSplit:      2,
    TopLeftCell: "A1",
    ActivePane:  "bottomLeft",
    Panes: []excelize.PaneOptions{
        {SQRef: "A1:65", ActiveCell: "A1", Pane: "bottomLeft"},
    },
})

[xuri]

Thanks for the feedback. This question similar with issue #981, please reference the documentation of the SetPanes function, we can freeze the first row like this:

err := f.SetPanes("Sheet1", &excelize.Panes{
    Freeze:      true,
    YSplit:      1,
    TopLeftCell: "A2",
    ActivePane:  "bottomLeft",
})

[aphsa]

Unfortunately your solution does not work :( Am i doing something wrong?
Please note I am using streamwriter. This is my entirety of my code below.

package main

import (
	"fmt"
	"math/rand"

	"github.com/xuri/excelize/v2"
)

func main() {
	file := excelize.NewFile()
	defer func() {
		if err := file.Close(); err != nil {
			fmt.Println(err)
		}
	}()
	streamWriter, err := file.NewStreamWriter("Sheet1")
	if err != nil {
		fmt.Println(err)
	}

	header := []interface{}{
		excelize.Cell{Value: "Name"},
		excelize.Cell{Value: "DummyH1"},
		excelize.Cell{Value: "DummyH2"},
	}
	err = streamWriter.SetRow("A1", header)

	if err != nil {
		fmt.Println(err)
	}

	for rowID := 2; rowID <= 165; rowID++ {
		row := make([]interface{}, 3)
		for colID := 0; colID < 3; colID++ {
			row[colID] = rand.Intn(640000)
		}
		cell, _ := excelize.CoordinatesToCellName(1, rowID)
		if err := streamWriter.SetRow(cell, row); err != nil {
			fmt.Println(err)
		}
	}

	err = file.SetPanes("Sheet1", &excelize.Panes{
		Freeze:      true,
		YSplit:      1,
		TopLeftCell: "A2",
		ActivePane:  "bottomLeft",
	})

	if err != nil {
		fmt.Println(err)	
	}
	if err := streamWriter.Flush(); err != nil {
		fmt.Println(err)
	}
	if err := file.SaveAs("Book1.xlsx"); err != nil {
		fmt.Println(err)
	}
}

[xuri]

Please reference the documentation of the stream writer, as the docs say: the normal mode functions and stream mode functions can't be work mixed. So when you using the stream writer, please freeze the first row with the stream mode SetPanes function in the stream writer. For example:

- err = file.SetPanes("Sheet1", &excelize.Panes{
+ err = streamWriter.SetPanes(&excelize.Panes{