This is a migrated thread and some comments may be shown as answers.

Not able Export Grid DateTime column

6 Answers 46 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Pranay
Top achievements
Rank 1
Pranay asked on 10 Aug 2012, 09:25 AM
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

 

6 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 10 Aug 2012, 10:18 AM
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

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Pranay
Top achievements
Rank 1
answered on 10 Aug 2012, 10:44 AM
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.
0
Vlad
Telerik team
answered on 10 Aug 2012, 10:48 AM
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

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Pranay
Top achievements
Rank 1
answered on 10 Aug 2012, 10:59 AM
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
0
Vlad
Telerik team
answered on 10 Aug 2012, 11:00 AM
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

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Pranay
Top achievements
Rank 1
answered on 10 Aug 2012, 11:07 AM
so what I have to do it for keep it on right side because i need it on right side.
Tags
GridView
Asked by
Pranay
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Pranay
Top achievements
Rank 1
Share this question
or