How to read date from excel sheet

[ifat420]

In the Excel file there is a cell:
E7 => 3/14/2000

I'm trying to get it...

cell, err := f.GetCellValue("Sheet1", "E7")
    if err != nil {
        fmt.Println(err)
        return
    }
println(cell)

Output: 03-14-00

output as sting format.
How can I convert it into go time.Time format
Thanks

[xuri]

Thanks for your issue, you can read raw cell values and convert them to time.Time by ExcelDateToTime like this:

cell, err := f.GetCellValue("Sheet1", "E7", excelize.Options{RawCellValue: true})
if err != nil {
    fmt.Println(err)
    return
}
excelDate, err := strconv.ParseFloat(cell, 64)
if err != nil {
    fmt.Println(err)
    return
}
excelTime, err := excelize.ExcelDateToTime(excelDate, false)
if err != nil {
    fmt.Println(err)
    return
}
fmt.Println(excelTime)

[ifat420]

Thanks for your issue, you can read raw cell values and convert them to time.Time by ExcelDateToTime like this:

cell, err := f.GetCellValue("Sheet1", "E7", excelize.Options{RawCellValue: true})
if err != nil {
    fmt.Println(err)
    return
}
excelDate, err := strconv.ParseFloat(cell, 64)
if err != nil {
    fmt.Println(err)
    return
}
excelTime, err := excelize.ExcelDateToTime(excelDate, false)
if err != nil {
    fmt.Println(err)
    return
}
fmt.Println(excelTime)

Thanks dude

[SmartZou]

When I use f.GetRows mode to read data, the above reference code output is a fixed value. The code is as follows
rows, _ := f.GetRows(config.BasicInformationSheetName)

[xuri]

Hi @SmartZou, which version of the library you're using? Please give a try with the master branch code, and if it still not work please provide your input file attachment without confidential info if you can.