EPPlus 5

Features and technical overview

Easier access to row and column properties.

New properties for Row and Column access

Two new index properties has been added to ExcelWorksheet to access row and column properties easier These properties works similar to the cell property

  • Rows
  • Columns
For example:
//Set rowheight of row 1 to 18 to 25
worksheet.Rows[1, 18].Height = 25;

ExcelRange also adds two new properties to access row and column data:

  • EntireRow
  • EntireColumn

//Set width to 18 for column A:C
worksheet.Cells["A1:C5"].EntireColumn.Width = 18;