protected void btnExcel_Click(object sender, EventArgs e) { DataTable data = new DataTable(); DataColumn DATE = data.Columns.Add("Date", typeof(string)); DataColumn ADULT = data.Columns.Add("Adult", typeof(string)); DataColumn CHILD = data.Columns.Add("Child", typeof(string)); DataColumn BABY = data.Columns.Add("Baby", typeof(string)); DataColumn PAX = data.Columns.Add("Total pax", typeof(string)); DataColumn TRIP1 = data.Columns.Add("Trip 1", typeof(string)); DataColumn TRIP2 = data.Columns.Add("Trip 2", typeof(string)); DataColumn DOUBLE_OCCUPIED = data.Columns.Add("Double occupied", typeof(string)); DataColumn DOUBLE_AVAILABLE = data.Columns.Add("Double available", typeof(string)); DataColumn TWIN_OCCUPIED = data.Columns.Add("Twin occupied", typeof(string)); DataColumn TWIN_AVAILABLE = data.Columns.Add("Twin available", typeof(string)); foreach (RepeaterItem item in rptBookingList.Items) { Label labelDate = (Label)item.FindControl("labelDate"); Literal litAdult = (Literal)item.FindControl("litAdult"); Literal litChild = (Literal)item.FindControl("litChild"); Literal litBaby = (Literal)item.FindControl("litBaby"); Literal litTotalPax = (Literal)item.FindControl("litTotalPax"); Literal litTrip1 = (Literal)item.FindControl("litTrip1"); Literal litTrip2 = (Literal)item.FindControl("litTrip2"); Literal litDouble = (Literal)item.FindControl("litDouble"); Literal litDoubleAvaiable = (Literal)item.FindControl("litDoubleAvaiable"); Literal litTwin = (Literal)item.FindControl("litTwin"); Literal litTwinAvaiable = (Literal)item.FindControl("litTwinAvaiable"); DataRow row = data.NewRow(); row[DATE] = labelDate.Text; row[ADULT] = litAdult.Text; row[CHILD] = litChild.Text; row[BABY] = litBaby.Text; row[PAX] = litTotalPax.Text; row[TRIP1] = litTrip1.Text; row[TRIP2] = litTrip2.Text; row[DOUBLE_OCCUPIED] = litDouble.Text; row[DOUBLE_AVAILABLE] = litDoubleAvaiable.Text; row[TWIN_OCCUPIED] = litTwin.Text; row[TWIN_AVAILABLE] = litTwinAvaiable.Text; data.Rows.Add(row); } ExcelExport excel = new ExcelExport("Web"); excel.ExportDetails(data, ExcelExport.ExportFormat.Excel, "booking.xls"); }