Remove Header Columns when export to excel and CSV

[bharat veer]

Hi,

we have a radgrid and we are binding the radgrid with datatable the grid height and width is "0px" while we export to excel or csv we want to remove its header column name is there any possiblities to remove this? Below is my code :

//HTML code
<telerik:RadGrid ID="rgExport" runat="server" Height="0" Width="0"
                    onitemdatabound="rgExporthierarchical_ItemDataBound"
                    onexcelmlexportrowcreated="rgExporthierarchical_ExcelMLExportRowCreated">
                </telerik:RadGrid>

//.CS file Code
rgExport.DataSource=dt;
rgExport.DataBind();

please reply soon we will very thankful to you.

thanks & regards
BHARAT VEER

[Daniel]

Hello Bharat,

You can remove the header row by setting ShowHeader to false. Simple demo is shown below:

<asp:Button ID="Button1" runat="server" Text="Export" />
<telerik:RadGrid ID="RG1" runat="server" />

protected override void OnInit(EventArgs e)
{
    base.OnInit(e);

    RG1.NeedDataSource += (s, a) =>
        {
            DataTable table = new DataTable();

            table.Columns.Add("Column1");
            table.Columns.Add("Column2");
            for (int i = 0; i < 10; i++)
                table.Rows.Add(i, i);
            RG1.DataSource = table;
        };

    Button1.Click += (s, a) =>
    {
        RG1.ShowHeader = false;
        RG1.Rebind();
        RG1.MasterTableView.ExportToCSV();
    };
}

Best regards,
Daniel
the Telerik team

[bharat veer]

Thanks Daniel !!!!! but it is only working for CSV. It is not working for Excel. Can you please provide me solution for excel as well as. Please reply soon.

[Princy]

Hello Bharat,

You can try the following code snippet to achieve your scenario.

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
      if (e.CommandName == RadGrid.ExportToExcelCommandName)
      {
          GridHeaderItem HeaderItem = (GridHeaderItem)RadGrid1.MasterTableView.GetItems(GridItemType.Header)[0];
          HeaderItem.Visible=false;
      }
}

Thanks,
Princy.

[Rasheed]

I want to remove the header of Detail Table.
How can it possible.
And moreover Itemcommand event is not firing when clicking on Export to Excel button.

[Eyup]

Hello Rasheed,

I've created a sample RadGrid web site to demonstrate how you can achieve the requested functionality. Please run the attached application and let me know if it helps you.

Regards,
Eyup
Telerik

 

 

[Jorge]

Hi

Not work for me!

Please see the picture. I need remove the header row for each DetailTables.

I hope your help!

[Eyup]

Hi Jorge,

Could you share your exporting settings and configuration so I can prepare a web site sample resembling your scenario?

Regards,
Eyup
Telerik