如何使用github.com/tealeg/xlsx获得工作表的名称？

Question

I am using github.com/tealeg/xlsx to read XLSX files. It is read pretty fast, however I would like to read by Sheet Name. Does anyone know how to do?

// by sheet index works fine

xlFile,err := xlsx.OpenFile(xlsFile)

for _,sheet := range xlFile.Sheets {

 for _,row := range sheet.Rows {

 }

}

Answer 1

Just use the map Sheet contained in xlsx.File and access by key (the key is your sheet name):

xlFile, err := xlsx.OpenFile(xlsFile)
// check err

sheetName := "YourSheetName"
sheet := xlFile.Sheet[sheetName]