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");
}
