Class FillDateParams

Parameters for the FillDateTime(Action<FillDateParams>) method

Inheritance

object

FillParams

FillDateParams

Inherited Members

FillParams.StartPosition

FillParams.Direction

FillParams.NumberFormat

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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
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
DateTime?

StepValue

The value to add for each step.

Declaration

public int StepValue { get; set; }

Property Value

Type	Description
int

Methods

SetExcludedDates(IEnumerable<DateTime>)

Excludes the dates supplied

Declaration

public void SetExcludedDates(IEnumerable<DateTime> holidayDates)

Parameters

Type	Name	Description
IEnumerable<DateTime>	holidayDates	The dates treated as week days

SetExcludedDates(params DateTime[])

Excludes the dates supplied

Declaration

public void SetExcludedDates(params DateTime[] holidayDates)

Parameters

Type	Name	Description
DateTime[]	holidayDates	The dates treated as week days

SetExcludedWeekdays(params DayOfWeek[])

Excludes the week days supplied

Declaration

public void SetExcludedWeekdays(params DayOfWeek[] weekdays)

Parameters

Type	Name	Description
DayOfWeek[]	weekdays	The excluded week days