SetSheetVisible for datagrip export excel, will panic: runtime error: invalid memory address or nil pointer dereference

[quxionglie]

Description

I use JetBrains datagrip database tool to export excel file, but using f.SetSheetVisible(sheet, false) will cause exception. But if I save it in excel and call f.SetSheetVisible(sheet, false) again, it will be normal.

step:
1.use datagrip，Right click on the SQL statement "execute to file " ,save as excel
2.call HideSheet(xxx)

input data : in.xlsx
in.xlsx

code:

func HideSheet(filename string) {
	slog.Info("处理文件", "filename", filename)
	f, err := excelize.OpenFile(filename)
	procError(err)

	defer func() {
		if err := f.Close(); err != nil {
			procError(err)
		}
	}()

	sheetList := f.GetSheetList()
	slog.Info("存在sheet列表", "sheetList", sheetList)
	if len(sheetList) == 2 {
		//隐藏第二个sheet
		sheet := sheetList[1]
		slog.Info("隐藏sheet", "sheet", sheet)
		err = f.SetSheetVisible(sheet, false)
		procError(err)

		err = f.SaveAs(filename)
		procError(err)
	}
}

func procError(err error) {
	if err != nil {
		slog.Info("错误", "err", err)
		os.Exit(-1)
	}
}

Output of go version:
go version go1.22.5 darwin/amd64

panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x28 pc=0x6fd04c0]

goroutine 1 [running]:
github.com/xuri/excelize/v2.(*File).SetSheetVisible(0xc000084540, {0xc00027c548, 0x5}, 0x0, {0x0, 0x0, 0xc000027ea8?})
        /Users/lie/go/pkg/mod/github.com/xuri/excelize/v2@v2.8.1/sheet.go:776 +0x3c0
main.HideSheet({0x702b1c0, 0x7})
        /Users/lie/goProjects/sql2excel/cmd/sheet/sheet_ctl.go:50 +0x287
main.main()
        /Users/lie/goProjects/sql2excel/cmd/sheet/sheet_ctl.go:15 +0x1f

Excelize version or commit ID:

github.com/xuri/excelize/v2 v2.8.1

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Microsoft® Excel for Mac 版本 16.87 (24071426)

[xuri]

Thanks for your issue. This issue has been fixed, please upgrade to the master branch code by go get -u github.com/xuri/excelize/v2@master, and this patch will be released in the next version.