[Solved] Export Grid data In Excel

[Vij]

Dear Experts,
I am newbie in using telerik controls.
I have 25 columns in my select command, in which I want to show only 5 columns to users on UI, but when user export that data in excel file then all 25 columns value should exported in  excel.
can any one have any Idea how I can achieve this.

Thanks
Vijendra

[Shinu]

Hi,

Try hiding the column before exportng as shown below.
c#;

protected void Button1_Click(object sender, EventArgs e)
{
        RadGrid1.MasterTableView.GetColumn("UniqueName1").Visible = false;
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Shinu

[Vij]

This will hide the column from the exported Excel, even I want just of it's reserve,
On UI 2-3 columns will display, but when user export the data in excel all 25 columns will be in excel file.

[Shinu]

Hi,

You can set the column's Display property as false and show them while exporting.
aspx:

<telerik:GridBoundColumn Display="false" DataField="ShipAddress" UniqueName="ShipAddress" ></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="OrderID" Display="false" UniqueName="OrderID"></telerik:GridBoundColumn>

c#:

protected void Button1_Click(object sender, EventArgs e)
{
        RadGrid1.MasterTableView.GetColumn("OrderID").Visible = true;
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Shinu