[Solved] Excel Export

[JC]

Hello,

Since I use the Q3 Beta, when I try to generate Excel files, with the same code that is used for Silverlight Q2, this exception is thrown:

 Telerik.Windows.Data.TypeExtensions.DefaultValue(Type type)

 Telerik.Windows.Data.Expressions.ExpressionFactory.DefaltValueExpression(Type type)

 Telerik.Windows.Data.Expressions.ExpressionFactory.MakeMemberAccess(Expression instance, String memberName, Type memberType)

 Telerik.Windows.Data.Expressions.ExpressionFactory.MakeMemberAccess(Expression instance, String memberName, Type memberType, Boolean liftMemberAccessToNull)

Telerik.Windows.Data.Expressions.PropertyAccessExpressionBuilder.CreateMemberAccessExpressionOverride()

 Telerik.Windows.Data.Expressions.MemberAccessExpressionBuilderBase.CreateMemberAccessExpression()

Telerik.Windows.Data.Expressions.MemberAccessExpressionBuilderBase.CreateLambdaExpression()

Telerik.Windows.Data.BindingToExpressionExtensions.CreateMemberAccessLambdaExpression(Binding binding, Type objectType, Type memberType)

 Telerik.Windows.Data.BindingToExpressionExtensions.CreateUntypedMemberAccessFunc(Binding binding, Type objectType, Type memberType)

 Telerik.Windows.Data.BindingToExpressionExtensions.CreateMemberAccessFunc(Binding binding, Type objectType, Type memberType)

 Telerik.Windows.Data.DataFieldDescriptorExtensions.CreateMemberAccessFunc(IDataFieldDescriptor fieldDescriptor)

 Telerik.Windows.Controls.GridViewBoundColumnBase.InitializeMemberAccessFunc()

Look's like a bug, I think !
JC

[Vlad]

Hi JC,

 The issue is already fixed. The exception is related to GridViewBoundColumnBase without declared DataMemberBinding - most probably you have some GridViewDataColumn without this.

Sincerely yours,
Vlad
the Telerik team

[JC]

Hello,
Thanks for your reply, howerver all my columns are binded : 

<core:SynGrid x:Name="_listSacoches" AutoGenerateColumns="False" RowIndicatorVisibility="Collapsed" IsSynchronizedWithCurrentItem="True" Margin="10" Grid.Row="1" >
  <core:SynGrid.Columns>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="BANQUE"                DataMemberBinding="{Binding AgenceDestinataire.Banque.Libelle}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="ROUTE"                 DataMemberBinding="{Binding Route}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="COLLECTE"              DataMemberBinding="{Binding Collecte}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="DATE COLLECTE"         DataMemberBinding="{Binding DateExpedition, StringFormat=d}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="HEURE COLLECTE"        DataMemberBinding="{Binding HeureExpedition}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="LIVRAISON"             DataMemberBinding="{Binding Livraison}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="DATE LIVRAISON"        DataMemberBinding="{Binding DateLivraison, StringFormat=d}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="HEURE LIVRAISON"       DataMemberBinding="{Binding HeureLivraison}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="NUMERO DE SACOCHE "    DataMemberBinding="{Binding ScanSacoche}"/>

    <tlk:GridViewDataColumn IsReadOnly="True" Header="CODE DESTINATAIRE"     DataMemberBinding="{Binding CodeAgenceDestinataire}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="TYPE DESTINATAIRE"     DataMemberBinding="{Binding AgenceDestinataire.TypeAgence.Libelle}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="NOM DESTINATAIRE"      DataMemberBinding="{Binding AgenceDestinataire.Libelle}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="ADRESSE DESTINATAIRE"  DataMemberBinding="{Binding AgenceDestinataire.Adresse.Ligne1}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="ZIP DESTINATAIRE"      DataMemberBinding="{Binding AgenceDestinataire.Adresse.CodePostal}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="VILLE DESTINATAIRE"    DataMemberBinding="{Binding AgenceDestinataire.Adresse.Ville}"/>

    <tlk:GridViewDataColumn IsReadOnly="True" Header="CODE EXPÉDITEUR"       DataMemberBinding="{Binding CodeAgenceExpediteur}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="TYPE EXPÉDITEUR"       DataMemberBinding="{Binding AgenceExpediteur.TypeAgence.Libelle}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="NOM EXPÉDITEUR"        DataMemberBinding="{Binding AgenceExpediteur.Libelle}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="ADRESSE EXPÉDITEUR"    DataMemberBinding="{Binding AgenceExpediteur.Adresse.Ligne1}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="ZIP EXPÉDITEUR"        DataMemberBinding="{Binding AgenceExpediteur.Adresse.CodePostal}"/>
    <tlk:GridViewDataColumn IsReadOnly="True" Header="VILLE EXPÉDITEUR"      DataMemberBinding="{Binding AgenceExpediteur.Adresse.Ville}"/>

    <tlk:GridViewDataColumn  Header="TYPE D'ANOMALIE"                        DataMemberBinding="{Binding Anomalie, Mode=TwoWay}"/>
    <tlk:GridViewDataColumn  Header="RAISON NON COLLECTE"                    DataMemberBinding="{Binding FauteAgence, Mode=TwoWay}"/>
    <tlk:GridViewDataColumn  Header="RAISON NON LIVRAISON"                   DataMemberBinding="{Binding FauteCPC, Mode=TwoWay}"/>
    <tlk:GridViewDataColumn  Header="COMMENTAIRE"                            DataMemberBinding="{Binding Commentaire, Mode=TwoWay}"/>
  </core:SynGrid.Columns>
</core:SynGrid>

Just, sometimes, the "DATE COLLECTE" colum is null, without it, it's work, pehaps this will help you.
Can you assure me that  xls export supports null values ?

I look forward to Q3 Release !!
Bye
JC

[JC]

Finaly I found the problem :
One of my column was bound to a property which no exist on the current entity 
Sorry for that