hi,
i try to export my grid data to excel with ExcelML format, i have column with timespan type and it stay empty in the export file,
how i can export this kind of type or other non primitive type
01.<telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" DataSourceID="ObjectDataSource1" AllowPaging="true" PageSize="20" OnExcelMLExportRowCreated="RadGrid1_OnExcelMLExportRowCreated">02. <MasterTableView CommandItemDisplay="Top" AutoGenerateColumns="False" DataKeyNames="Index" DataSourceID="ObjectDataSource1" UseAllDataFields="True">03. <Columns>04. <telerik:GridBoundColumn DataField="Index" DataType="System.Guid" HeaderText="Index"05. ReadOnly="true" Visible="false" SortExpression="Index" UniqueName="Index">06. </telerik:GridBoundColumn>07. <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName"08. UniqueName="FirstName">09. </telerik:GridBoundColumn>10. <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" SortExpression="LastName"11. UniqueName="LastName">12. </telerik:GridBoundColumn>13. <telerik:GridBoundColumn DataField="Age" DataType="System.Int32" HeaderText="Age"14. SortExpression="Age" UniqueName="Age">15. </telerik:GridBoundColumn>16. <telerik:GridBoundColumn DataField="Time" DataType="System.TimeSpan" HeaderText="Time"17. SortExpression="Time" UniqueName="Time">18. </telerik:GridBoundColumn>19. </Columns>20. </MasterTableView>21. <ExportSettings ExportOnlyData="true" />22. </telerik:RadGrid>23. <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetContacts" TypeName="myClasses.ContactList"></asp:ObjectDataSource>
i attach image how it look after the export
i can get to the cell of this type under the OnExcelMLExportRowCreated event but the data is read only and i can't change it