Class FillDateParams

Parameters for the FillDateTime(Action<FillDateParams>) method

Inheritance
System.Object
FillParams
FillDateParams
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Core.Worksheet.Fill
Assembly: EPPlus.dll
Syntax
public class FillDateParams : FillParams

Properties

DateTimeUnit

The date unit added per cell

Declaration
public eDateTimeUnit DateTimeUnit { get; set; }
Property Value
Type Description
eDateTimeUnit

EndValue

When this value is exceeded the fill stops

Declaration
public DateTime? EndValue { get; set; }
Property Value
Type Description
System.Nullable<System.DateTime>

StartValue

The start value. If null, the first value in the row/column is used. Direction

Declaration
public DateTime? StartValue { get; set; }
Property Value
Type Description
System.Nullable<System.DateTime>

StepValue

The value to add for each step.

Declaration
public int StepValue { get; set; }
Property Value
Type Description
System.Int32

Methods

SetExcludedDates(IEnumerable<DateTime>)

Excludes the dates supplied

Declaration
public void SetExcludedDates(IEnumerable<DateTime> holidayDates)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<System.DateTime> holidayDates

The dates treated as week days

SetExcludedDates(DateTime[])

Excludes the dates supplied

Declaration
public void SetExcludedDates(params DateTime[] holidayDates)
Parameters
Type Name Description
System.DateTime[] holidayDates

The dates treated as week days

SetExcludedWeekdays(DayOfWeek[])

Excludes the week days supplied

Declaration
public void SetExcludedWeekdays(params DayOfWeek[] weekdays)
Parameters
Type Name Description
System.DayOfWeek[] weekdays

The excluded week days