excel中同样是自定义类型的时间,在DataGridView中显示为什么不一样?
excel中的数据:
DataGridView中显示为:
第三列的日期后面为什么会多出来时间?
代码:
Dim k As Integer = 0
Dim itemArray As Object()
For i As Integer = 0 To ds.Tables("sheet").Rows.Count - 1
Me.DataGridView1.Rows.Add()
k = Me.DataGridView1.Rows.Count
itemArray = ds.Tables("sheet").Rows(i).ItemArray
For j As Integer = 0 To itemArray.Length - 1
Me.DataGridView1.Rows(k - 1).Cells(j).Value = itemArray(j).ToString
Next
Next