grid export to ExcelML TimeSpan column

1 posts, 0 answers
  1. Adi
    Adi avatar
    2 posts
    Member since:
    Jul 2017

    Posted 28 Aug 2017 Link to this post


    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

Back to Top