ndt80
28-08-2005, 17:33
Minh mo 1 file Excel trong VB.Net. Trong file excel nay co mot column with DateTime type. Nhung khi minh doc data cua column nay thi data bi convert sang double number. ex:
Cell B1: 6/4/05
nhung khi doc:
Dim data as string = WS.Cells(1,2).Value2
va duoc: 38507
Co ai biet cach nao de convert lai thanh Date&Time khong
Co phai minh de open file wrong way?
Cell B1: 6/4/05
nhung khi doc:
Dim data as string = WS.Cells(1,2).Value2
va duoc: 38507
Co ai biet cach nao de convert lai thanh Date&Time khong
Co phai minh de open file wrong way?