Can RadGrid have export to Excel [.xlsx] functionality ?

8 posts, 0 answers
  1. Perfect
    Perfect avatar
    40 posts
    Member since:
    Sep 2010

    Posted 11 Nov 2011 Link to this post

    Hi ,
    We are using Telerik Q2 2011 version.
    We have requirement of generating excel 2007 files [.xlsx files].

    Can RadGrid have export to Excel [.xlsx] functionality ?

    I checked the RadGrid export method and not found any suitable methods to generate .xlsx files.
    In our current version we don't find any RadGrid1.MasterTableView.ExportToExcel2007(); method. Just  I find RadGrid1.MasterTableView.ExportToExcel(). this can be open .xls files only.

    Please I need to close asap this issue, so any one can help me on this


    Advance Thanks
    Mr.Perfect
  2. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 11 Nov 2011 Link to this post

    Hello,

    You can take a look into the following forum thread which discussed the same.
    EXport RadGrid to Excel 2007

    Thanks,
    Princy.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Perfect
    Perfect avatar
    40 posts
    Member since:
    Sep 2010

    Posted 11 Nov 2011 Link to this post

    Hi Princy,
     
      Thank you for your quick reply, I check and inform to you.

    Thank's
    Mr. Perfect
  5. J
    J avatar
    1 posts
    Member since:
    Aug 2010

    Posted 20 Aug 2014 Link to this post



    To Telerik team:

    It would be very helpful if the ExportToExcel function of the radgrid could export the data to the .xlsx format.  Many users have the later version of Excel and every time the export occurred with the .xls extension, this message came up and it’s not very
    user friendly.

    "The file you are trying to open,<file.xls>, is in a different format than specified by the file extension.  Verify that the file is not corrupted and is from a trusted source before opening the file.  Do you want to open the file now?"




     

    Joseph Chan

  6. Daniel
    Admin
    Daniel avatar
    4945 posts

    Posted 22 Aug 2014 Link to this post

    Hello Joseph,

    We are actively working on this task. Xlsx should be available for the next official release. In the meantime you could use the BIFF XLS format which won't trigger that warning message.
    Excel export online demo

    Regards,
    Daniel
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  7. Eric
    Eric avatar
    24 posts
    Member since:
    Jul 2011

    Posted 28 Aug 2014 Link to this post

    Looking forward to this update.  Thanks.
  8. Nilar
    Nilar avatar
    3 posts
    Member since:
    Apr 2012

    Posted 23 Dec 2014 Link to this post

    Any update on .xlsx format?
  9. Daniel
    Admin
    Daniel avatar
    4945 posts

    Posted 24 Dec 2014 Link to this post

    Hello Nilar,

    Please examine the following resources:
    RadGrid Export to Excel demo
    XLSX and DOCX Export

    I hope this helps.

    Regards,
    Daniel
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017