private List<Row> GetRows(Worksheet worksheet, int start, int end) { List<Row> temp = new List<Row>(); for(int i=start;i<=end;i++) { temp.Add(worksheet.GetFirstChild<SheetData>().Elements<Row>().Where(r => r.RowIndex == i).First()); } return temp; }