Export From Multiple Grid to Excel and PDF Formate

Export From Multiple Grid to Excel and PDF Formate

protected void btn_Exportxecel_Click(object sender, EventArgs e)
        {
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=Export.xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.xls";

            StringWriter StringWriter = new System.IO.StringWriter();
            HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Personal Detail" + "</b></td></tr></table>");
            Grid_PersonalDetail.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Address Deteail" + "</b></td></tr></table>");
            gridadress.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Invoice Detail" + "</b></td></tr></table>");
            grd_Invoicedetail.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Product Detail" + "</b></td></tr></table>");
            grd_product.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "AMC/CMC Detail" + "</b></td></tr></table>");
            grd_AMC.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Service Detail" + "</b></td></tr></table>");
            grid_Service.RenderControl(HtmlTextWriter);
          

            Response.Write(StringWriter.ToString());
            Response.End();
        }

        protected void btn_exporttoPdf_Click(object sender, EventArgs e)
        {
            CssClass_GridView(gridadress);

            StringWriter sw0 = new StringWriter();
            HtmlTextWriter hw0 = new HtmlTextWriter(sw0);
            if (gridadress != null && gridadress.Rows.Count > 0)
            {
                hw0.Write("<table width='100%'><tr ><td><font size='5' color='white' align='left' style='text-align:left;'>");
                hw0.Write("Expense Record");
                hw0.Write("</font></td></tr>");
                hw0.Write("<tr><td>");
                hw0.Write("<font size='1' align='left' style='text-align:left;'>");
                StringWriter sw2 = new StringWriter();
                //EnableEventValidation = "false";
                //this.EnableViewState = False;
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Personal Detail" + "</b></td></tr></table>");
                Grid_PersonalDetail.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9'></td></tr></table>");
                gridadress.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Invoice Deteail" + "</b></td></tr></table>");
                grd_Invoicedetail.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Product Deteail" + "</b></td></tr></table>");             
                grd_product.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "AMC/CMC Deteail" + "</b></td></tr></table>");
                grd_AMC.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Service Deteail" + "</b></td></tr></table>");
                grid_Service.RenderControl(new HtmlTextWriter(sw2));
                string html = sw2.ToString();
                hw0.Write(html);
                hw0.Write("</font>");
                hw0.Write("</td></tr></table>");
                StringReader sr = new StringReader(sw0.ToString().Replace("%20", " "));
                Document pdfDoc = new Document(PageSize.A4, 9f, 9f, 9f, 0f);
               //
            
              
             
                iTextSharp.text.html.simpleparser.HTMLWorker htmlparser = new iTextSharp.text.html.simpleparser.HTMLWorker(pdfDoc);
                string filename = Session["UserName"].ToString() + "_Details_" + DateTime.Now.Ticks + ".pdf";
                string file_Path = "~\\ExportFiles\\" + filename;
                PdfWriter.GetInstance(pdfDoc, new FileStream(Server.MapPath(file_Path), FileMode.Create));
                pdfDoc.Open();
                htmlparser.Parse(sr);
                pdfDoc.Close();
                // Response.Redirect("../ExportFiles/" + filename);
                Response.Redirect("../ExportFiles/" + filename, "_blank", "menubar=0,scrollbars=1,width=780,height=900,top=10");
            }
            else
            {
                ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", "alert('There Is No Data To Export Here. Please Fill Data  Firstly....')", true);
            }
        }

        protected void CssClass_GridView(GridView NewGrid)
        {
            NewGrid.Style.Add("width", "100%");
            NewGrid.Attributes.Add("ShowFooter", "True");
            NewGrid.Attributes.Add("CellPadding", "1");
            NewGrid.Font.Size = 10;
            NewGrid.ForeColor = System.Drawing.Color.FromArgb(51, 51, 51);
            NewGrid.GridLines = GridLines.None;
            NewGrid.ShowFooter = true;
            NewGrid.AlternatingRowStyle.BackColor = System.Drawing.Color.White;
            NewGrid.EditRowStyle.BackColor = System.Drawing.Color.FromArgb(36, 97, 191);
            NewGrid.FooterStyle.BackColor = System.Drawing.Color.FromArgb(80, 124, 209);
            NewGrid.FooterStyle.Font.Bold = true;
            NewGrid.FooterStyle.ForeColor = System.Drawing.Color.White;
            NewGrid.HeaderStyle.BackColor = System.Drawing.Color.FromArgb(80, 124, 209);
            NewGrid.HeaderStyle.Font.Bold = true;
            NewGrid.HeaderStyle.ForeColor = System.Drawing.Color.White;
            NewGrid.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
            NewGrid.RowStyle.BackColor = System.Drawing.Color.FromArgb(239, 243, 251);
            NewGrid.RowStyle.HorizontalAlign = HorizontalAlign.Left;
        }