Reading Datetime value From Excel sheet

by

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);

More Related Contents:

  1. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  2. Get instance of Excel application with C# by Handle
  3. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  4. The quest for the Excel custom function tooltip
  5. How to make correct date format when writing data to Excel
  6. Importing Excel into a DataTable Quickly
  7. How to save workbook without showing save dialog with Excel interop?
  8. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  9. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  10. Accessing an open Excel Workbook in C#
  11. How to convert a column number (e.g. 127) into an Excel column (e.g. AA)
  12. How to read data of an Excel file using C#?
  13. Reading excel file using OLEDB Data Provider
  14. Closing Excel Application Process in C# after Data Access
  15. How to get the range of occupied cells in excel sheet
  16. What is the algorithm to convert an Excel Column Letter into its Number?
  17. How to use use late binding to get excel instance?
  18. Cell color changing in Excel using C#
  19. Disposing of Microsoft.Office.Interop.Word.Application
  20. Read from word document line by line
  21. How can I quickly up-cast object[,] into double[,]?
  22. How To Write To A OneNote 2013 Page Using C# and The OneNote Interop
  23. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  24. C# – How to copy a single Excel worksheet from one workbook to another?
  25. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  26. Accessing Excel Custom Document Properties programmatically
  27. Query excel sheet in c#
  28. Open XML SDK 2.0 – how to update a cell in a spreadsheet?
  29. Get the Column Index of a Cell in Excel using OpenXML C#
  30. Exception (HRESULT: 0x800AC472) when using Excel.Worksheet.Select after calling Excel.Workbook.SaveAs

Leave a Comment