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