How to remove Command itemtemplate in xls sheet

[sudheer]

Hi all,
i have a hierarchical grid,   i m using Command itemtemplate to show end user add ,edit ,delete,e.t.c . (not as columns inside grid)  if i try to export hierarchical grid to excel sheet  it is exporting add,edit, including with images(items included inside Command item template ). but i don't want to show all those options in XLS. how can i overcome this problem .

Anyhelp

[Daniel]

Hello Sudheer,

Set ExportOnlyData="true" either in the declaration or in code-behind.
Export to Microsoft Excel/Word/PDF/CSV

I hope this helps.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[sudheer]

Hi

Thanks for reply.
This works fine for level 1 grid .  but for level2  grid it's is not working.

Thanks for help

[Princy]

Hi Sudheer,

You may try hiding the CommandItem for the detail table in the click event of the export button as shown below.

CS:

protected void Button1_Click(object sender, EventArgs e)

{

foreach (GridDataItem item in RadGrid1.Items)

{

//access the Detail table using the name property

if (item.OwnerTableView.Name=="Detail")

{

GridTableView childTable = (GridTableView)item.OwnerTableView;

foreach (GridCommandItem cmditem in childTable.GetItems(GridItemType.CommandItem))

{

cmditem.Visible = false;

}

}

}

RadGrid1.ExportSettings.OpenInNewWindow = true;

RadGrid1.ExportSettings.ExportOnlyData = true;

RadGrid1.MasterTableView.ExportToExcel();

}

Regards
Princy.

[sudheer]

Hi princy,

Thanks for reply,

Even though my problem not get solved . in excel sheet  it is generating refresh image and add new record link of detail table.

please give a solution bcoz in excel it look's weird ,end user not happy.

[Princy]

Hello Sudheer,

Check if you have set the Name property of the detail table on the aspx. Then try accessing the DetailTable using the name property as shown below:
aspx:

<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" runat="server">
   <MasterTableView DataSourceID="SqlDataSource1" CommandItemDisplay="Top" Name="Master">
      <DetailTables>
         <telerik:GridTableView DataSourceID="SqlDataSource2" CommandItemDisplay="Top" Name="Detail" runat="server" >
            .....

cs:

protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (GridDataItem item in RadGrid1.Items)
        {
           //access the Detail table using the name property
            if (item.OwnerTableView.Name=="Detail")
            {

                GridTableView childTable = (GridTableView)item.OwnerTableView;
                    foreach (GridCommandItem cmditem in childTable.GetItems(GridItemType.CommandItem))
                    {
                        cmditem.Visible = false;
                    }


            }
        }

        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.MasterTableView.ExportToExcel();

Thanks
Princy.

[sudheer]

Hi princy ,

My issue not at solved even if use your code . and i found debugger going inside while execution.
and in excel first column is getting empty.to resolve that i used below code .

(GRIDNAME.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem)["ExpandColumn"].Visible = false;

foreach (GridDataItem dataItem in GRIDNAME.MasterTableView.Items)

{

dataItem["ExpandColumn"].Style["display"] = "none";

dataItem["ExpandColumn"].Visible = false;

}

eventhough no chance , can u guide .