When i am trying to export data from gridview to excel i an also getting hyperlink along with that how can i remove that before export below is my code ltdiv align34right34 style34paddingtop5px paddingright5px34gt ltspan title34Export Data to Excel34gtltaspImageButton ID34btnExporttoExcel34 runat34server34 ImageUrl34imgExcelLogopng34

You will have to remove the HyperLink and then export Check the below sample ltaspGridView ID34GridView134 HeaderStyleBackColor343AC0F234 HeaderStyleForeColor34White34 RowStyleBackColor34A1DCF234 AlternatingRowStyleBackColor34White34 AlternatingRowStyleForeColor3400034 runat34server34 AutoGenerateColumns34false34 AllowPaging34true34 OnPageIndexChanging34OnPageIndexChanging34gt ltColumnsgt ltaspBoundField DataField34ContactName34 HeaderText34Contact Name34 ItemStyleWidth34150px34 gt ltaspTemplateField HeaderText34City34gt ltItemTemplategt ltaspHyperLink ID34lnkCity34 runat34server34 NavigateUrl3434 Text39lt Eval34City34 gt39gtltaspHyperLinkgt ltItemTemplategt ltaspTemplateFieldgt

GridView Export to Excel Remove HyperLinks

priyanka...

SOLVED CLOSED ACTIVE ANSWERED
User: priyanka88
Posted: on May 12, 2013 11:45 PM
Forum: Data Controls
Answer: 1
Views: 15248

When i am trying to export data from gridview to excel i an also getting hyperlink along with that, how can i remove that before export. below is my code

<div align="right" style="padding-top:5px; padding-right:5px"> 
                      
                                <span title="Export Data to Excel"><asp:ImageButton ID="btnExporttoExcel" 
                                     runat="server" ImageUrl="~/img/Excel_Logo.png" 
                                     onclick="btnExporttoExcel_Click" /></span>
                                 <span title="Export Data to Word"><asp:ImageButton ID="btnExporttoWord" 
                                    runat="server" ImageUrl="~/img/Word_Logo.png" onclick="btnExporttoWord_Click" /></span>
                                  <span title="Export Data to Pdf"><asp:ImageButton ID="btnExporttopdf" 
                                    runat="server" ImageUrl="~/img/pdf_Logo.png" onclick="btnExporttopdf_Click" /></span>
                            </div>
 <div style="height:470px" class="fontInside">
                            <asp:GridView ID="gridCompany" runat="server" 
                                                             AllowPaging="True" PageSize="18" 
                                    CssClass="mGrid" PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt"
                        onpageindexchanging="gridCompany_PageIndexChanging" AutoGenerateColumns="false" 
                                    GridLines="None" HeaderStyle-CssClass="fontInside" AllowSorting="true"
                                DataKeyNames="Company_Id" onsorting="gridCompany_Sorting"  
                                HeaderStyle-ForeColor="Black">
                                                <PagerSettings FirstPageText="First Page" LastPageText="Last Page" 
                         Mode="NextPreviousFirstLast" NextPageText="Next Page" 
                        PreviousPageText="Previous Page" />
                                                <AlternatingRowStyle CssClass="alt" />
                                                <Columns>
                                                <asp:TemplateField>
                                                <HeaderTemplate>
                                                    <asp:CheckBox ID="chkHeader" runat="server" onclick = "checkAll(this);"/>
                                                </HeaderTemplate>
                                                <ItemTemplate>
                                                <asp:CheckBox ID="chkChild" runat="server"/>
                                                </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Company" HeaderStyle-Width="250px" SortExpression="CompanyName" ItemStyle-CssClass="fontInside">
                                                <ItemTemplate>
                                                <asp:HyperLink ID="HyperLink1" runat="server" ForeColor="#0681ab" Font-Underline="false" NavigateUrl='<%#"BasicCompanyHome.aspx?CompanyName="+DataBinder.Eval(Container.DataItem,"CompanyName")+"&CompanyID="+DataBinder.Eval(Container.DataItem,"Company_Id")%>' Text='<%#Eval("CompanyName")%>'></asp:HyperLink>
                                                </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:BoundField DataField="Phone_No" HeaderText="Phone" ItemStyle-CssClass="fontInside" SortExpression="Phone_No"/>
                                                <asp:BoundField DataField="Revenue" HeaderText="Revenue" ItemStyle-CssClass="fontInside" SortExpression="Revenue"/>
                                                <asp:BoundField DataField="Employees" HeaderText="Employees"  ItemStyle-CssClass="fontInside" SortExpression="Employees"/>
                                                <asp:BoundField DataField="All_Industries" HeaderText="Industry"  ItemStyle-CssClass="fontInside" SortExpression="All_Industries"/>
                                                <asp:BoundField DataField="All_Countries" HeaderText="Country" ItemStyle-CssClass="fontInside" SortExpression="All_Countries"/>
                                                <asp:BoundField DataField="Status" HeaderText="Status"  ItemStyle-CssClass="fontInside" SortExpression="Status"/>
                                               </Columns>
                                                <PagerStyle CssClass="pgr" Font-Size="Small" />
                                            <AlternatingRowStyle CssClass="alt" />
                                            </asp:GridView>
</div>

.cs

protected void btnExporttoExcel_Click(object sender, ImageClickEventArgs e)
    {
        //FunctionForExportandDocument("attachment;filename=GridViewExport.xls", "application/vnd.ms-excel");
}
private void FunctionForExportandDocument(string header, string contentType)
        {
            
            SaveCheckedValuesForSheetORDoc();
            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", header);
            Response.Charset = "";
            Response.ContentType = contentType;
            StringWriter _objstringbuilder = new StringWriter();
            HtmlTextWriter _objhtmltextwriter = new HtmlTextWriter(_objstringbuilder);
            gridCompany.AllowPaging = false;
            string id = Session["id"].ToString();
            if (Convert.ToInt32(id) < 9999)
            {
                BindCompaniesFree();
            }
            else
            {
                BindCompanies();
            }
            gridCompany.HeaderRow.Style.Add("background-color", "#FFFFFF");
            gridCompany.HeaderRow.Cells[0].Visible = false;
            for (int i = 0; i < gridCompany.HeaderRow.Cells.Count; i++)
            {
                GridViewRow row = gridCompany.Rows[i];
                gridCompany.HeaderRow.Cells[i].Style.Add("background-color", "#FFFFFF");
                gridCompany.HeaderRow.Cells[i].Style.Add("text-Underline", "None");
                gridCompany.HeaderRow.Cells[i].Style.Add("color", "#FFFFFF");
                PrepareControlForExport(row);
                //HyperLink rowNumOfStores = (HyperLink)row.Cells[1].Controls[0];
                //rowNumOfStores.Enabled = false;
            }
            
            if (ViewState["CHECKED_ITEMS_DISPLAY"] != null)
            {
                ArrayList CheckBoxArray = (ArrayList)ViewState["CHECKED_ITEMS_DISPLAY"];
                for (int i = 0; i < gridCompany.Rows.Count; i++)
                {
                    GridViewRow _objgridrow = gridCompany.Rows[i];
                    _objgridrow.Visible = false;
                    int index = _objgridrow.RowIndex;
                    if (CheckBoxArray.Contains(index))
                    {
                        _objgridrow.Visible = true;
                        _objgridrow.Cells[0].Visible = false;
                    }
                }
            }
            gridCompany.RenderControl(_objhtmltextwriter);
            Response.Output.Write(_objstringbuilder.ToString());
            Response.End();
        }
private void SaveCheckedValuesForSheetORDoc()
        {
            ArrayList _objuserdetails = new ArrayList();
            int _itemindexnumber = 0;
            foreach (GridViewRow gvrow in gridCompany.Rows)
            {
                _itemindexnumber = gvrow.RowIndex;
                CheckBox chkvalidate = (CheckBox)gvrow.FindControl("chkChild");
                if (ViewState["CHECKED_ITEMS_DISPLAY"] != null)
                    _objuserdetails = (ArrayList)ViewState["CHECKED_ITEMS_DISPLAY"];
                if (chkvalidate.Checked == true)
                {
                    if (!_objuserdetails.Contains(_itemindexnumber))
                    {
                        _objuserdetails.Add(_itemindexnumber);
                    }
                }
                else
                {
                    _objuserdetails.Remove(_itemindexnumber);
                }
            }
            if (_objuserdetails != null && _objuserdetails.Count > 0)
            {
                ViewState["CHECKED_ITEMS_DISPLAY"] = _objuserdetails;
            }
        }

public override void VerifyRenderingInServerForm(Control control)
    {

        // Confirms that an HtmlForm control is rendered for the
        //specified ASP.NET server control at run time.

    }

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on May 12, 2013 11:46 PM
Report

You will have to remove the HyperLink and then export. Check the below sample

    <asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
        RowStyle-BackColor="#A1DCF2" AlternatingRowStyle-BackColor="White" AlternatingRowStyle-ForeColor="#000"
        runat="server" AutoGenerateColumns="false" AllowPaging="true" OnPageIndexChanging="OnPageIndexChanging">
        <Columns>
            <asp:BoundField DataField="ContactName" HeaderText="Contact Name" ItemStyle-Width="150px" />
            <asp:TemplateField HeaderText="City">
                <ItemTemplate>
                    <asp:HyperLink ID="lnkCity" runat="server" NavigateUrl="#" Text='<%# Eval("City") %>'></asp:HyperLink>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Country">
                <ItemTemplate>
                    <asp:TextBox ID="txtCountry" runat="server" Text='<%# Eval("Country") %>'></asp:TextBox>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Country">
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" Text = "Checked" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Country">
                <ItemTemplate>
                    <asp:RadioButton ID="RadioButton1" runat="server" Text = "Checked" />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <br />
    <asp:Button ID="btnExport" runat="server" Text="Export To Excel" OnClick="ExportToExcel" />

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.BindGrid();
        }
    }

    private void BindGrid()
    {
        string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(strConnString))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                    }
                }
            }
        }
    }

    protected void OnPageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        this.BindGrid();
    }

    protected void ExportToExcel(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
        Response.Charset = "";
        Response.ContentType = "application/vnd.ms-excel";
        using (StringWriter sw = new StringWriter())
        {
            HtmlTextWriter hw = new HtmlTextWriter(sw);

            //To Export all pages
            GridView1.AllowPaging = false;
            this.BindGrid();

            GridView1.HeaderRow.BackColor = Color.White;
            foreach (TableCell cell in GridView1.HeaderRow.Cells)
            {
                cell.BackColor = GridView1.HeaderStyle.BackColor;
            }
            foreach (GridViewRow row in GridView1.Rows)
            {
                row.BackColor = Color.White;
                foreach (TableCell cell in row.Cells)
                {
                    if (row.RowIndex % 2 == 0)
                    {
                        cell.BackColor = GridView1.AlternatingRowStyle.BackColor;
                    }
                    else
                    {
                        cell.BackColor = GridView1.RowStyle.BackColor;
                    }
                    cell.CssClass = "textmode";
                    List<Control> controls = new List<Control>();
                    foreach (Control control in cell.Controls)
                    {
                        switch (control.GetType().Name)
                        {
                            case "HyperLink":
                                controls.Add(control);
                                break;
                            case "TextBox":
                                controls.Add(control);
                                break;
                            case "LinkButton":
                                controls.Add(control);
                                break;
                            case "CheckBox":
                                controls.Add(control);
                                break;
                            case "RadioButton":
                                controls.Add(control);
                                break;
                        }
                    }
                    foreach (Control control in controls)
                    {
                        switch (control.GetType().Name)
                        {
                            case "HyperLink":
                                cell.Controls.Add(new Literal { Text = (control as HyperLink).Text });
                                break;
                            case "TextBox":
                                cell.Controls.Add(new Literal { Text = (control as TextBox).Text });
                                break;
                            case "LinkButton":
                                cell.Controls.Add(new Literal { Text = (control as LinkButton).Text });
                                break;
                            case "CheckBox":
                                cell.Controls.Add(new Literal { Text = (control as CheckBox).Text });
                                break;
                            case "RadioButton":
                                cell.Controls.Add(new Literal { Text = (control as RadioButton).Text });
                                break;
                        }
                        cell.Controls.Remove(control);
                    }
                }
            }

            GridView1.RenderControl(hw);
            
            //style to format numbers to string
            string style = @"<style> .textmode { mso-number-format:\@; } </style>";
            Response.Write(style);
            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.End();
        }
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        /* Verifies that the control is rendered */
    }

GridView Export to Excel Remove HyperLinks

Company

Explore

Follow us

Contact Us