EPPlus 5/6/7

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;