private void ExportToExcel(DataTable dataTable, string[] Column)
    {
       
        if (dataTable.Rows.Count > 0)
        {
            Response.Clear();
            Response.ContentType = "application/vnd.xls";
            Response.Charset = "";
            Response.AddHeader("content-disposition", "attachment;FileName= PaymentReport.xls");
            if (Column != null && Column.Length > 0)
            {
                RemoveColumns(dataTable, Column);
            }
            GridView gv = new GridView();
            gv.DataSource = dataTable;
            gv.DataBind();
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            gv.RenderControl(htw);
            Response.Write("
");
            Response.Write(sw.ToString());
            Response.End();
        }
        else
        {
            lblError.Text = "No Data !";
        }
    }