Skip to content

Range operations

Ranges can be copied, inserted, deleted, filled and sorted. EPPlus adjusts formulas and other references in the workbook that are affected by the change.

  • Copying ranges/sheets - Copy ranges, values without formulas, styles or entire worksheets, within a workbook or to another workbook.
  • Insert/Delete - Insert and delete rows, columns and ranges, with formulas, tables, pivot tables, conditional formatting and drawings adjusted.
  • Filling ranges - Fill a range with numbers, dates or a list of values with FillNumber, FillDateTime and FillList.
  • Sorting ranges - Sort the rows or columns of a range on one or more columns or rows, ascending, descending or by a custom list.