Cannot export two columns with same DataField

[Ricky]

   <Columns>
                    <telerik:GridHyperLinkColumn Text="Edit" AllowFiltering="false" DataNavigateUrlFields="ReservationId"
                        DataNavigateUrlFormatString="/admin/order/details?id={0}&action=edit" />
                    <telerik:GridHyperLinkColumn Text="View" AllowFiltering="false" DataNavigateUrlFields="ReservationId"
                        DataNavigateUrlFormatString="/admin/OrderPreview.ashx?id={0}" Target="_blank" />
                    <telerik:GridBoundColumn UniqueName="ReservationId" HeaderText="Reservation Id" DataField="ReservationId"
                        Exportable="True" CurrentFilterFunction="EqualTo" ShowFilterIcon="false" AutoPostBackOnFilter="True"
                        FilterControlWidth="100%" Display="True" Visible="True">
                    </telerik:GridBoundColumn>
</Columns>

RadGrid2.MasterTableView.Columns[0].Visible = false;
RadGrid2.MasterTableView.Columns[1].Visible = false;

RadGrid2.MasterTableView.Columns[0].Display = false;
RadGrid2.MasterTableView.Columns[1].Display = false;

Column 3 still cannot display when exported to Excel File because they have the same DataField.
Any idears? Thank you so much!

[Princy]

Hi Ricky,

I was not able to replicate such an issue at my end. Please try the below sample code snippet. You can use the UniqueName of the column to hide it during export. Provide your code snippet if this doesn't help.

ASPX:

<asp:Button ID="Button1" runat="server" Text="Export to Excel" OnClick="Button1_Click"/>
<telerik:RadGrid ID="RadGrid1" runat="server">
    <MasterTableView UseAllDataFields="true">
        <Columns>
          <telerik:GridHyperLinkColumn Text="Edit" DataNavigateUrlFields="ID" UniqueName="Edit" />
          <telerik:GridHyperLinkColumn Text="View"  DataNavigateUrlFields="ID" UniqueName="View" />
          <telerik:GridBoundColumn UniqueName="ID" HeaderText="ID" DataField="ID"/>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void Button1_Click(object sender, EventArgs e)
{
  RadGrid1.ExportSettings.ExportOnlyData = true;
  RadGrid1.ExportSettings.IgnorePaging = true;
  RadGrid1.ExportSettings.OpenInNewWindow = true;
  //Hide columns on Export
  RadGrid1.MasterTableView.GetColumn("Edit").Visible = false;
  RadGrid1.MasterTableView.GetColumn("View").Visible = false;
  RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Princy