RAD Grid - Export to excel - Adding worksheet dynamically

4 posts, 0 answers
  1. Meenakshi Nagalingam
    Meenakshi Nagalingam avatar
    53 posts
    Member since:
    Aug 2009

    Posted 31 Aug 2009 Link to this post

    Hi,


    I have the following requirement in our application and i'm using RAD Grid Q2 2009 version:
    1. The records in the grid should be grouped based on say column A
    2. While exporting to excel, it should export the data in new worksheet for every new group (here column A).

    Item# 1 can be achieved using <GroupByFieldsoption that comes with the grid. 

    While exploring options for Item# 2, i came to know from the following url, 


    we can override ExcelML exporting. So i thought of using RadGrid1_ExcelMLExportRowCreated event since that would be the apt event to create a worksheet for my requirement. But i couldn't find any stuff to create worksheet dynamically! 

    Please let me know is that achievable?

    Thanks

  2. Sebastian
    Admin
    Sebastian avatar
    9798 posts
    Member since:
    Sep 2012

    Posted 03 Sep 2009 Link to this post

    Hello Meenakshi,

    Unfortunately the export functionality you request (exporting different groups in separate Excel sheets) is not supported by our web grid. I hope that exporting the entire grid in a single Excel sheet is feasible workaround for your situation.

    Nevertheless, I will appreciate if you direct us to online resources or other web grids which have this type of functionality integrated. Thus we will research the matter further to consider it for implementation.
     
    Kind regards,
    Sebastian
    the Telerik team


    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

  3. Agm
    Agm avatar
    26 posts
    Member since:
    Sep 2012

    Posted 17 Jan 2013 Link to this post

    Hi Sebastian,

    I want to export 100 records from RadGrid to 10 work sheets that having 10 records per sheet.

    please give a solution for this.

    Thanks in advance.

    AGMRAJA

  4. Agm
    Agm avatar
    26 posts
    Member since:
    Sep 2012

    Posted 17 Jan 2013 Link to this post

    Hi Sebastian,

    I want to export 100 records from RadGrid to 10 work sheets that having 10 records per sheet.

    please give a solution for this.

    Thanks in advance.

    AGMRAJA

Back to Top