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.Direction
FillParams.NumberFormat
FillParams.StartPosition
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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(params DateTime[])¶

Excludes the dates supplied

public void SetExcludedDates(params DateTime[] holidayDates)

Parameters¶

holidayDates DateTime[]

The dates treated as week days

SetExcludedDates(IEnumerable<DateTime>)¶

Excludes the dates supplied

public void SetExcludedDates(IEnumerable<DateTime> holidayDates)

Parameters¶

holidayDates IEnumerable<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