Export Excel GridTemplateColumn + RadComboBox

[Lasly]

Hi ,
When I Export to Excel from a  RadGrid then everything is fine, but if I Export RadGrid with GridTemplateColumn and RadComboBox as an  ItemTemplate, then the Value, DataValueField  ,of the RadComboBox  it show instead of the DataTextField.
How can extract the radcombox  DataTextField instead of  DataValueField  ?
thanks

[Princy]

Hello,

Try the following.
ASPX:

<telerik:RadGrid ID="radgrid1" runat="server" DataSourceID="SqlDataSource1">
  <ExportSettings ExportOnlyData="false" Excel-Format="Html">
  </ExportSettings>
  <MasterTableView CommandItemDisplay="Top">
    <CommandItemSettings ShowExportToExcelButton="true" />
    <Columns>
      <telerik:GridTemplateColumn HeaderText="test">
        <ItemTemplate>
          <telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource1" DataTextField="LastName" DataValueField="EmployeeID">
          </telerik:RadComboBox>
        </ItemTemplate>
      </telerik:GridTemplateColumn>
    </Columns>
  </MasterTableView>
</telerik:RadGrid>

Thanks,
Princy.

[Lasly]

Many thanks for your answer, but does not work:
 1) export the DataTextField, but of all the items of radcombobox
 2) export the combo box and the select button. (+ All the buttons, because ExportOnlyData = "false")

does it work for You?

How do i solve this? ( I have so many pages with this problem)

 

thank you very much

[Daniel]

Hi Lasly,

I created a simple demo based on the code posted by Princy. Please test it locally and see if it helps.

Regards,
Daniel
the Telerik team