Disable Export to Excel

[Manav]

Is there anyway I can disable the export to excel on my grids on the right click menu?

[Daniel]

Hello Manav,

It depends on your scenario. Generally it would be a better approach not to show the export option rather than to cancel the export. If you post more details I will be able to provide straight-to-the-point answer.

Best regards,
Daniel
the Telerik team

[Manav]

Hi Daniel,
  Basically, I do not want the user to be able to download the data from my grid to excel. How do i do this? Also, is there a way i can do it on a master page and it gets applied to all the grids?

[Manav]

Hi Daniel,
  Is there any update on this issue?
In case the question is still not clear, I do not want the user to be able to download the data from the grid as this may be confidential data which may be in the grid

Can you please advice.
Thanks

[Daniel]

Hello Manav,

A possible approach would be to remove the Export item from the context menu:

<telerik:RadContextMenu ID="RadContextMenu1" runat="server" OnPreRender="RadContextMenu1_PreRender">
    <Targets>
        <telerik:ContextMenuElementTarget ElementID="outerDiv" />
    </Targets>
    <Items>
        <telerik:RadMenuItem Text="Export" />
        <telerik:RadMenuItem Text="Edit" />
        <telerik:RadMenuItem Text="Delete" />
    </Items>
</telerik:RadContextMenu>

protected void RadContextMenu1_PreRender(object sender, EventArgs e)
{
    if (!SomeCondition)
    {
        RadContextMenu rcm = sender as RadContextMenu;
        rcm.Items.Remove(rcm.FindItemByText("Export"));
    }
}

Generally speaking, the latest point where it is possible to cancel the export is on GridExporting event.

void RadGrid1_GridExporting(object sender, GridExportingArgs e)
{
    if (!SomeCondition)
    {
        Response.Redirect(Request.Url.ToString());
    }
}

Best regards,
Daniel
the Telerik team

[Manav]

Hi Daniel,
   Apologies but looks like you havent got my question still. I dont have a context menu at all. I only have the grid in my complete page.However,  the standard windows right click menu shows an option of Export to Excel on the Radgrid

[Daniel]

Hello Manav,

I thought you use a context menu because you said:

I can disable the export to excel on my grids on the right click menu?

The option that you are referring to has nothing to do with Telerik RadControls. This functionality is added to the context menu of your browser by Microsoft Office.

Best regards,
Daniel
the Telerik team