excel - 在 golang 中读取 excel 文件时出错

Question

我正在尝试下面的代码，但出现错误

"multiple-value cell.String() in single-value context"

代码

 package main
import (
"fmt"
"github.com/tealeg/xlsx"
 )
 func main() { 
     excelFileName := "test.xlsx"
     xlFile, err := xlsx.OpenFile(excelFileName)
     if err != nil {

     }
 for _, sheet := range xlFile.Sheets {
    for _, row := range sheet.Rows {
          for _, cell := range row.Cells {
            fmt.Printf("%s ", cell.String(), "123")
  }
            fmt.Printf("\n")
  }
  }
 }
}

Answer 1

改变

for _, cell := range row.Cells {
    fmt.Printf("%s ", cell.String(), "123")
}

到

for _, cell := range row.Cells {
    val, _ := cell.String()
    fmt.Printf("%s ", val)
}