excel - 遍历golang中的列单元格并进行excelize

Question

我想知道如何在golang中循环excel表格的列单元格，这是我的excel文件:

我出于其他原因尝试了这段代码

package main

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

func main() {

    f, err := excelize.OpenFile("pricematching.xlsx")
    if err != nil {
        fmt.Println(err)
        return
    }

    // Get all the rows in the sheet1 section.
    rows, err := f.GetCellValue("sheet1", "A2")

    fmt.Print(rows, "\t")

}

Answer 1

无论您的 excel 文件如何，这都是读取每个单元格的方式:

xlsxFile, error := excelize.OpenFile(filePath)
for _, sheetName := range xlsxFile.GetSheetMap() {
   for rowIndex, rowValues := range xlsxFile.GetRows(sheetName) {
      for columnIndex, columnValue := range rowValues {
         // do what ever you want here
      }
   }
}