Not able Export Grid DateTime column

[Pranay]

When I export gridview with the datetime column its generates excel file but its not opening .

I looked in generated excel xml its having formate like this for date time column

<

Cell ss:StyleID="GeneralDate" ss:Index="2"><Data ss:Type="DateTime">2012-05-31T00:00:00.000</Data></Cell>


fore more detail I have attached image files


if possible help asap.

Regards

 

[Vlad]

Hello,

 Do you have the same problem with our demo when exporting to ExcelML? We have DateTime in our ItemsSource as well. 

All the best,
Vlad
the Telerik team

[Pranay]

its working fine at my end can you please provide me demo project for this if possible .

One mreo thing i m  using latest rad control dll.

[Vlad]

Hi,

 You can check your local copy of our demos for more. Our demos are always build against our latest components. 

All the best,
Vlad
the Telerik team

[Pranay]

There is one more thing when I exported in XAML formate date is treated as string and is left align can i do some change in that and make it align right.

check attahced file for more detail

[Vlad]

Hello,

 This can happen if you have StringFormat for the Binding to DataFormatString for the column. In this case your original value is converted to string with specified format. 

Regards,
Vlad
the Telerik team

[Pranay]

so what I have to do it for keep it on right side because i need it on right side.