Not able Export Grid DateTime column

7 posts, 0 answers
  1. Pranay
    Pranay avatar
    11 posts
    Member since:
    Jul 2012

    Posted 10 Aug 2012 Link to this post

    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

     

  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 10 Aug 2012 Link to this post

    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.

  3. Pranay
    Pranay avatar
    11 posts
    Member since:
    Jul 2012

    Posted 10 Aug 2012 Link to this post

    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.
  4. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 10 Aug 2012 Link to this post

    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.

  5. Pranay
    Pranay avatar
    11 posts
    Member since:
    Jul 2012

    Posted 10 Aug 2012 Link to this post

    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
  6. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 10 Aug 2012 Link to this post

    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.

  7. Pranay
    Pranay avatar
    11 posts
    Member since:
    Jul 2012

    Posted 10 Aug 2012 Link to this post

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