"github.com/360EntSecGroup-Skylar/excelize"
func readExcel() {
file, err := excelize.OpenFile("D:\\theWayGo\\src\\gotest\\base-package\\os\\dir2\\ws_erp_20181227.xlsx")
if err != nil {
log.Println(err.Error())
}
sheet := file.GetSheetMap()
rl := list.New()
for _, v := range sheet {
rows := file.GetRows(v)
if len(rows) <= 0 {
log.Println("未能读取到行数据!")
continue
}
for _, n := range rows {
if len(n) <= 0 {
log.Println("行数据为空!")
continue
}
rl.PushBack(n)
}
}
fmt.Println(rl.Len())
//按顺序遍历
for e := rl.Front(); e != nil; e = e.Next() {
fmt.Println(e.Value)
}
}
网友评论