protected void btnExport_Click(object sender, EventArgs e)
{
ExcelPackage package = new ExcelPackage();
EppTools tools = new EppTools();
//
string fileName = "VolumeWeekReport";
//string year = ddlYear.SelectedValue;]
string dateFrom = tbStart.Text.Trim();
string dateTo = tbEnd.Text.Trim();
dateFrom = dateFrom != string.Empty ? dateFrom : "all";
dateTo = dateTo != string.Empty ? dateTo : "all";
int kioskid = Convert.ToInt32(ddlKiosk.SelectedItem.Value);
DataTable table = Common.GetVolumeWeekReport(dateFrom, dateTo, kioskid);
//
tools.GenerateVolumeWeekReport(table, ref package, fileName);
//
var ws = package.Workbook.Worksheets[fileName];
//
// HEADER TITLE FORMATING
ws.Cells[2, 1].Value = "VOLUME (WEEK) REPORT ";
ws.Cells[3, 1].Value = "Date From: ";
ws.Cells[4, 1].Value = "Agent: " + GlobalAccess.Username;
ws.Cells[2, 1, 4, 1].Style.Font.Bold = true;
ws.Cells[2, 1, 4, 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
// SAVING EXCEL FILE
Response.Clear();
Response.BinaryWrite(package.GetAsByteArray());
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=\"" + "VolumeWeek_Report.xlsx\"");
Response.Flush();
Response.End();
package = null;
ws = null;
//
}
