C# Class Smrf.AppLib.ExcelDateTimeUtil

Static utility methods for working with Excel dates and times.

Inheritance: Object

Show file Open project: 2014-sed-team3/term-project

Public Methods

Method	Description
DateTimeToExcelDecimal ( System.DateTime dateTime ) : Decimal
DateTimeToString ( System.DateTime dateTime, ExcelColumnFormat format ) : String
DateTimeToString ( System.DateTime dateTime, ExcelColumnFormat format, IFormatProvider formatProvider ) : String
DateTimeToString ( System.Int64 ticks, ExcelColumnFormat format ) : String
DateTimeToStringLocale1033 ( System.DateTime dateTime, ExcelColumnFormat format ) : String
ExcelDecimalToDateTime ( Decimal excelDecimal ) : System.DateTime

Private Methods

Method	Description
AssertValid ( ) : void
ExcelDateTimeUtil ( ) : System	Static constructor for the ExcelDateTimeUtil class.

Method Details

DateTimeToExcelDecimal() public static method

public static DateTimeToExcelDecimal ( System.DateTime dateTime ) : Decimal
dateTime	System.DateTime
return	Decimal

DateTimeToString() public static method

public static DateTimeToString ( System.DateTime dateTime, ExcelColumnFormat format ) : String
dateTime	System.DateTime
format	ExcelColumnFormat
return	String

DateTimeToString() public static method

public static DateTimeToString ( System.DateTime dateTime, ExcelColumnFormat format, IFormatProvider formatProvider ) : String
dateTime	System.DateTime
format	ExcelColumnFormat
formatProvider	IFormatProvider
return	String

DateTimeToString() public static method

public static DateTimeToString ( System.Int64 ticks, ExcelColumnFormat format ) : String
ticks	System.Int64
format	ExcelColumnFormat
return	String

DateTimeToStringLocale1033() public static method

public static DateTimeToStringLocale1033 ( System.DateTime dateTime, ExcelColumnFormat format ) : String
dateTime	System.DateTime
format	ExcelColumnFormat
return	String

ExcelDecimalToDateTime() public static method

public static ExcelDecimalToDateTime ( Decimal excelDecimal ) : System.DateTime
excelDecimal	Decimal
return	System.DateTime