Tag: Office

Cannot find Microsoft Date and Time Picker ActiveX control in Excel 2013

I was able to solve this problem by install Visual Basic 6.0 and Service Pack 6 for VB6, the control is in mscomctl2.ocx file.

Alternatively, the problem can be solved by installing the windows common controls pack manually.

Follow the article: https://support.microsoft.com/en-us/kb/957924

And it seems in order to install this pack, Visual Basic 6.0 sp6 needs to be installed?

Read DateTime data from Excel file using C#

Excel files are very tricky to deal with, sometimes it returns double value, sometimes just plain string.

The example processes values read by EPPlus, might be useful in other situations, too.

public DateTime GetDate(object valFromExcel)
{
if(valFromExcel is DateTime) return valFromExcel;
if(valFromExcel is double) return DateTime.FromOADate((double)valFromExcel);
return Convert.ToDateTime(valFromExcel);
}