复现方法:建立一个D:\test.xlsx,第一个单元格A1输入任意时间比如2023-05-09 15:50:02,或者省事点敲个=Now()
Dim f As String = "D:\test.xlsx"
Dim wb As New XLS.Book(f)
Dim sht As XLS.Sheet = wb.Sheets(0)
Output.Show(sht(0, 0).value)
结果为2023-05-09,而不是预期的2023-05-09 15:50:02
本来我以为是C1Excel的bug,但实际不是这样:
Dim f As String = "D:\test.xlsx"
Dim wb As C1Excel.C1XLBook = New C1Excel.C1XLBook()
wb.Load(f)
Dim sht As C1Excel.XLSheet = wb.Sheets(0)
Output.Show(sht(0, 0).value)
结果为2023-05-09 15:50:02,是正确的