[Solved] export RadGrid to Excel

[Abhi Shinde]

HI,

I want to use export data to excel of radGrid.
But My radGrid is showing only 5 columns from a DB table. I want export all columns of that table.
is that possible?

I dont want to show all the columns in radGrid.

[Jayesh Goyani]

Hello,

Please check my below code snippet.

<Columns>

                  <telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID" SortExpression="ID">

                  </telerik:GridBoundColumn>

                  <telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="Name" SortExpression="Name">

                  </telerik:GridBoundColumn>

                  <telerik:GridBoundColumn DataField="Address" HeaderText="Address" UniqueName="Address"
                                                  Visible="false">

                  </telerik:GridBoundColumn>

                  <telerik:GridBoundColumn DataField="Email" HeaderText="Email" UniqueName="Email"
                         Visible="false">

                  </telerik:GridBoundColumn>
</Columns>

Protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            if (e.CommandName == Telerik.Web.UI.RadGrid.ExportToExcelCommandName ||
                e.CommandName == Telerik.Web.UI.RadGrid.ExportToWordCommandName ||
                e.CommandName == Telerik.Web.UI.RadGrid.ExportToCsvCommandName)
            {
                RadGrid1.MasterTableView.Columns.FindByUniqueName("Address").Visible = true;

        RadGrid1.MasterTableView.Columns.FindByUniqueName("Email").Visible = true;
            }
        }

Let me know if any concern.

Thanks,
Jayesh Goyani

[Abhi Shinde]

hi Jayesh,

above logic is not working with GridTemplateColumn.

<telerik:GridTemplateColumn HeaderText="Edit" visible="false" AllowFiltering="false" UniqueName="EditColumn12" >
                        <ItemTemplate>
                            <asp:Label ID="lblAfter1212" runat="server" Text='<%# Eval("_4s") %>'> </asp:Label>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>

Gv.MasterTableView.GetColumn("EditColumn12").Visible = true;

If  visible="false" then that column will not come in excel file.
I am waiting for ur reply.

[Jayesh Goyani]

Hello,

Please check below code snippet.

RadGrid1.MasterTableView.GetColumn("EditColumn12").Visible = true;
RadGrid1.Rebind();

Let me know if any concern.

Thanks,
Jayesh Goyani