DateTimeToNumber Method

Converts the specified System.DateTime to a date-time serial number appropriate for storage in a worksheet cell.

[Visual Basic]
Overridable Function DateTimeToNumber( _
   ByVal dateTime As Date _
) As Double

[C#]
virtual double DateTimeToNumber( 
   DateTime dateTime
);

[C++]
virtual double DateTimeToNumber( 
   DateTime dateTime
) 

[C++/CLI]
virtual double DateTimeToNumber( 
   DateTime dateTime
) 

Parameters

dateTime

The System.DateTime instance to convert.

Return Type

A date-time serial number appropriate for storage in a worksheet cell.

Remarks

Dates and times are stored in worksheet cells as a date-time serial number.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbook Interface  | IWorkbook Members  | NumberToDateTime Method  | Date1904 Property

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.