package main

import (
	"fmt"
	"github.com/xuri/excelize/v2"
)

// 读取数据

func readExcel(filename string) (interface{}, []string, error) {
	f, err := excelize.OpenFile("books.xlsx")
	if err != nil {
		return nil, nil, err
	}
	defer func() {
		if err := f.Close(); err != nil {
		}
	}()
	// 获取 Sheet1 上所有单元格
	rows, err := f.GetRows("Sheet1")
	if err != nil {
		return nil, nil, err
	}
	//获取分组
	allMap := make([]map[string]string, 0)
	groupMap := make(map[string]string, 0)
	groupSlice := make([]string, 0)
	for k, row := range rows {
		var tmp = make(map[string]string, 0)
		if k > 0 {
			for kk, colCell := range row {
				//fmt.Print(colCell, "\t")
				if kk == 0 {
					if _, ok := groupMap[colCell]; !ok {
						groupSlice = append(groupSlice, colCell)
						groupMap[colCell] = colCell
					}
					tmp["catName"] = colCell

				}
				if kk == 1 ||colCell==""{
					continue
					tmp["name"] = colCell
				}
				if kk == 2 {
					tmp["content"] = colCell
				}
				allMap = append(allMap, tmp)
			}
		}
	}
	return allMap, groupSlice, nil
}
func main() {
	rs, groupData, _ := readExcel("")
	fmt.Println(rs)
	fmt.Println(groupData)
}