阅读DateTime值从Excel工作表 [英] Reading Datetime value From Excel sheet
问题描述
当我试图读取Excel工作表中它返回一个双值。例如DateTime类型值,如果想读值'2007-02-19 14:11:45.730'
这样,我得到。进一步,我使用的时间跨度转换这一双重价值的双重类型值,但因为我得到只有这个值无法成功完成'2007-02-19 12:00 :00 AM'
结果
现在我想完全相同的时间值作为第一个。我的code是这样的: -
when am trying to read datetime type value from excel sheet it is returning a double value.for example if want to read value '2007-02-19 14:11:45.730'
like this, i am getting a double type value .further i am converting this double value using timespan,but not complete successfully because i am getting only this value '2007-02-19 12:00:00 AM'
now i want exact same datetime value as first one. My code is like :-
TimeSpan datefromexcel = new TimeSpan(Convert.ToInt32((range.Cells[rCnt, cCnt] as Excel.Range).Value2), 0, 0, 0);
DateTime inputdate = new DateTime(1900, 1, 1).Add(datefromexcel);
arrrow2[cCnt - 1] = inputdate.ToString();
请帮助!
谢谢你。
Please help!!! Thanks.
推荐答案
您需要使用DateTime.FromOADate日期格式从OLE自动化转换为.NET格式。
You need to convert the date format from OLE Automation to the .net format by using DateTime.FromOADate.
double d = double.Parse(b);
DateTime conv = DateTime.FromOADate(d);
这篇关于阅读DateTime值从Excel工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!