protected void btnExportToExcel_Click(object sender, EventArgs e)
{
SalesRepresentativeReportingChild obj = new SalesRepresentativeReportingChild();
DataSet ds = obj.GetSKPickingBoard2("Select One", "Select One", "Select One", "Select One", "Select One", "Select One", "Select One");//, "Select One");
WorkbookEngine we = new WorkbookEngine();
we.ExportDataSetToExcel(ds.Tables[0], "Sales Representative Reporting");
}
protected void btnexcelDownload_Click(object sender, EventArgs e)
{
ModalPopupExtender2.Hide();
BusinessUnitReportingChild obj = new BusinessUnitReportingChild();
DataSet ds = obj.GetSKPickingBoard2("Select One", "Select One", "Select One");
WorkbookEngine we = new WorkbookEngine();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (!dr.IsNull("ExpirationDate"))
{
dr.Delete();
}
//DateTime expirationDate = Convert.ToDateTime(dr["ExpirationDate"].ToString());
}
we.ExportDataSetToExcel(ds.Tables[0], "BusinessUnit Reporting");
}