https://github.com/qax-os/excelize

    1. package main
    3. import (
    4.     "fmt"
    5.     "github.com/360EntSecGroup-Skylar/excelize"
    6.     "math/rand"
    7.     "os"
    8. )
    10. func main() {
    11.     xlsx, err := excelize.OpenFile("./1_3.xlsx")
    12.     if err != nil {
    13.         fmt.Println(err)
    14.         os.Exit(1)
    15.     }
    16.     rows := xlsx.GetRows("菏泽实验中学")
    17.     i := 0
    18.     var list1 = make([]string, 0)
    19.     var list2 = make([]string, 0)
    20.     var list3 = make([]string, 0)
    21.     var list4 = make([]string, 0)
    22.     var list5 = make([]string, 0)
    24.     for _, row := range rows {
    25.         if i == 0 {
    26.             i++
    27.             continue
    28.         }
    29.         for _, colCell := range row {
    31.             fmt.Print(colCell, "\t")
    32.             i++
    33.             fmt.Println(i)
    34.             flag := true
    35.             for flag {
    36.                 i2 := rand.Int() % 5
    37.                 fmt.Println(i2)
    38.                 switch i2 {
    39.                 case int(0):
    41.                     if len(list1) != 10 {
    42.                         fmt.Println(11111111)
    43.                         list1 = append(list1, colCell)
    44.                         flag = false
    45.                         fmt.Println("退出循环")
    46.                     }
    47.                 case int(1):
    48.                     if len(list2) <= 10 {
    49.                         list2 = append(list2, colCell)
    50.                         flag = false
    51.                     }
    52.                 case int(2):
    53.                     if len(list3) <= 10 {
    54.                         list3 = append(list3, colCell)
    55.                         flag = false
    56.                     }
    57.                 case int(3):
    58.                     if len(list4) <= 10 {
    59.                         list4 = append(list4, colCell)
    60.                         flag = false
    61.                     }
    62.                 case int(4):
    63.                     if len(list5) <= 10 {
    64.                         list5 = append(list5, colCell)
    65.                         flag = false
    66.                     }
    67.                 }
    68.             }
    69.             break
    70.         }
    71.         fmt.Println()
    72.     }
    74.     fmt.Println(list1)
    75.     fmt.Println(list2)
    76.     fmt.Println(list3)
    77.     fmt.Println(list4)
    78.     fmt.Println(list5)
    80.     for true {
    82.     }
    83. }