Class FillDateParams

Namespace

OfficeOpenXml.Core.Worksheet.Fill

Assembly

EPPlus.dll

Parameters for the FillDateTime(Action<FillDateParams>) method

public class FillDateParams : FillParams

Inheritance

object

FillParams

FillDateParams

Inherited Members

FillParams.StartPosition

FillParams.Direction

FillParams.NumberFormat

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

FillDateParams()

public FillDateParams()

Properties

DateTimeUnit

The date unit added per cell

public eDateTimeUnit DateTimeUnit { get; set; }

Property Value

eDateTimeUnit

EndValue

When this value is exceeded the fill stops

public DateTime? EndValue { get; set; }

Property Value

DateTime?

StartValue

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

public DateTime? StartValue { get; set; }

Property Value

DateTime?

StepValue

The value to add for each step.

public int StepValue { get; set; }

Property Value

int

Methods

SetExcludedDates(IEnumerable<DateTime>)

Excludes the dates supplied

public void SetExcludedDates(IEnumerable<DateTime> holidayDates)

Parameters

holidayDates IEnumerable<DateTime>

The dates treated as week days

SetExcludedDates(params DateTime[])

Excludes the dates supplied

public void SetExcludedDates(params DateTime[] holidayDates)

Parameters

holidayDates DateTime[]

The dates treated as week days

SetExcludedWeekdays(params DayOfWeek[])

Excludes the week days supplied

public void SetExcludedWeekdays(params DayOfWeek[] weekdays)

Parameters

weekdays DayOfWeek[]

The excluded week days