Fill ranges - DON-PHAM/EPPlus GitHub Wiki

ws.SetValue("A1",50);
//FillNumber with no parameters will fill the range using the value in the top-left cell as start value and increment it by 1 for each cell in the column. If the range has multiple columns the first value in the column will be used as start value.
ws.Cells["A1:A20"].FillNumber();

//Fill with a start value of 30 and decrease by 2.
ws.Cells["B1:B20"].FillNumber(30, -2);

//Fill by starting with 100 and increase 5% for each cell. Fill to the left by row
ws.Cells["E1:AA1"].FillNumber(x =>
{
  x.CalculationMethod = eCalculationMethod.Multiply;
  x.StartValue = 100;
  x.StepValue = 1.05;
  x.Direction = eFillDirection.Row;
});

//Default Fill, starting from the value in the top-left cell increase by one day per cell.
ws.SetValue("A2", new DateTime(2021, 1, 1));
ws.Cells["A2:A60"].FillDateTime();

//Fill from a start date and increase with two months per cell.
ws.Cells["B2:B60"].FillDateTime(new DateTime(2021, 6, 30), eDateTimeUnit.Month, 2);

//Fill dates per last day of the quarter. If the start value is the last day of the month, this is used for all dates in the fill. 
//This sample exclude weekends and adds some holiday dates. 
//Column C2 and D2 are used as start values.
ws.Cells["C2"].Value = new DateTime(2015, 6, 30);
ws.Cells["D2"].Value = new DateTime(2009, 2, 28);
ws.Cells["C2:D60"].FillDateTime(x =>
{
  x.DateTimeUnit = eDateTimeUnit.Month;
  x.StepValue = 3;
  x.NumberFormat = "yyyy-mm-dd";
  x.SetExcludedWeekdays(DayOfWeek.Saturday, DayOfWeek.Sunday); //We exclude weekends. The day before is used instead.
  x.SetExcludedDates(                                          //These dates are also excluded. The day before is used instead.
    new DateTime(2010, 12, 31),
    new DateTime(2012, 12, 31),
    new DateTime(2013, 12, 31),
    new DateTime(2014, 12, 31),
    new DateTime(2015, 12, 31),
    new DateTime(2015, 12, 31),
    new DateTime(2018, 12, 31),
    new DateTime(2019, 12, 31),
    new DateTime(2020, 12, 31),
    new DateTime(2021, 12, 31),
    new DateTime(2024, 12, 31),
    new DateTime(2025, 12, 31),
    new DateTime(2026, 12, 31),
    new DateTime(2027, 12, 31),
    new DateTime(2029, 12, 31)
  );
});

var list = new[] { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" };
ws.SetValue("A1", "FillList-Default");
FillList repeates the list. By default it starts from the first item at position 0
ws.Cells["A2:A20"].FillList(list);

//Starts at position 6 in the list
ws.Cells["B2:B20"].FillList(list,  x=> { x.StartIndex=6; });

//Fill per row
ws.Cells["F1:AA1"].FillList(list, x => 
{ 
  x.Direction = eFillDirection.Row;
});

//Fill the list of primes starting from the bottom-up.
//We set the range to the size of the list so it's not repeated.
var primes = new List<int>{ 2,5,7,11,13,17,19,23,29,997,1009 };
ws.Cells[2,3,primes.Count+1, 3].FillList(primes, x =>
{
  x.NumberFormat = "#,##0";
  x.StartPosition = eFillStartPosition.BottomRight;
});