在golang 中使用excel.md

获取地址

go get github.com/tealeg/xlsx

读取xlsx

package main

import (

    "fmt"

    "github.com/tealeg/xlsx"

)

func main() {

    excelFileName := "test.xlsx"

    xlFile, err := xlsx.OpenFile(excelFileName)

    if err != nil {

        fmt.Printf("open failed: %s\n", err)

    }

    for _, sheet := range xlFile.Sheets {

        fmt.Printf("Sheet Name: %s\n", sheet.Name)

        for _, row := range sheet.Rows {

            for _, cell := range row.Cells {

                text := cell.String()

                fmt.Printf("%s\n", text)

            }

        }

    }

}