[Solved] Export to excel show class name - using MVVM

[Yuk]

When we click the export to excel, the file display class name as follows. Any idea?

System.Windows.Controls.ContentControl
MyNameSpace.Model.LoanReport
MyNameSpace.Model.LoanReport
MyNameSpace.Model.LoanReport

We inject MVVM model using MEF

 Sample of gridview xaml

<telerik:RadGridView x:Name="GridLoans" Grid.Row="1" AutoGenerateColumns="False" ShowGroupPanel="False"
                    IsFilteringAllowed="True" FontSize="10" ItemsSource="{Binding LoanListCollection}" d:DesignHeight="300"
                     ShowColumnFooters="True"  IsReadOnly="True" MaxHeight="600"
                                  >
                <telerik:RadGridView.Columns>
                  
                    <telerik:GridViewDataColumn  SortMemberPath="GroupCode" Width="100">
                        <telerik:GridViewDataColumn.Header>
                            <ContentControl>
                                <StackPanel Orientation="Vertical">
                                    <TextBlock Text="Group Id" HorizontalAlignment="Left" />
                                </StackPanel>
                            </ContentControl>
                        </telerik:GridViewDataColumn.Header>
                        <telerik:GridViewDataColumn.CellTemplate>
                            <DataTemplate>
                                <TextBlock Text="{Binding Path=GroupCode}" VerticalAlignment="Center" TextTrimming="WordEllipsis"
                                        HorizontalAlignment="Left" />
                            </DataTemplate>
                        </telerik:GridViewDataColumn.CellTemplate>
                    </telerik:GridViewDataColumn>
    </telerik:RadGridView.Columns>
         </telerik:RadGridView>

  public class LoanReport
    {
        private int Id {get;set;}

        public string GroupCode { get; set; }
    }

 

ViewModel injected with MEF

[PartCreationPolicy(CreationPolicy.NonShared)]
    [Export(Constants.ViewModel, typeof(ViewModelBase))]
    public class LoanReportViewModel : ViewModelBase
    {

 ....

   private ObservableCollection<LoanReport> loanListCollection;

        /// <summary>
        /// Loan Collection
        /// </summary>
        public virtual ObservableCollection<LoanReport> LoanListCollection
        {
            get
            {
                if (loanListCollection == null)
                {
                    loanListCollection = new ObservableCollection<LoanReport>();
                }

                UpdateQuaterPayment(loanListCollection);

                return loanListCollection;
            }

            set
            {
                loanListCollection = value;
               RaiseCollectionChange();
            }
        }

     }

[Yuk]

Looks like I need to create the DataMemberBinding

what about the header?

[Vlad]

Hi,

 For custom header and templates you can use ElementExporting event and set desired value to e.Value similar to this demo. 

All the best,
Vlad
the Telerik team