Excel Delete SheetID Example

main.go

package main

import (
	"fmt"

	"github.com/360EntSecGroup-Skylar/excelize/v2"
)

func main() {
	xlsx := excelize.NewFile()
	xlsx.SetSheetName("Sheet1", "First Sheet")
	xlsx.NewSheet("Second Sheet")
	xlsx.NewSheet("Third Sheet")
	xlsx.NewSheet("Fourth Sheet")
	xlsx.DeleteSheet("Third Sheet")
	names := make([]string, 3)
	for i := 1; i <= 3; i++ {
		name := xlsx.GetSheetName(i)
		names[i-1] = name
		fmt.Printf("%d => %s\n", i, name)
	}
	for _, name := range names {
		fmt.Printf("Index: %d, name: %s\n", xlsx.GetSheetIndex(name), name)
	}
}

Use GetSheetMap instead of handle sheet index manuly:

for idx, name := range xlsx.GetSheetMap() {
    println("Index:", idx, "GetSheetIndex:", xlsx.GetSheetIndex(name), "name:", name)
}

Using GetSheetMap would be a workaround for now but GetSheetMap not being broken doesn't make GetSheetName and GetSheetIndex not broken.