Kindly provide how to hide the column and rows in sheet say (i.e) i need to hide rows 1 to 50 how can i do. below code is uesd to hide only 0th row.
sheet.Cells.SetRowHeight(0, new Unit(0, UnitType.Point));
But i need to hide the Row from 1 to 50
sheet.Cells.SetRowHeight(0:50, new Unit(0, UnitType.Point));