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

Rad Grid Excel like Filter & Excel automation

1 Answer 205 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Navneet
Top achievements
Rank 1
Navneet asked on 01 Jul 2011, 04:28 AM
Hi,

1) Is there a way to provide excel like filter capability (Selecting one or more items) for RadGrid? I see this behavior is available to RAD Grid for WinForms.

2) Also, I understand that there is a way to export rad grid to excel. But I want to export data to excel as the excel has the logic to generate pivot tables once I feed the data. Is there a way to achieve this? My Goal is just provide the data in xml format to the excel and send the excel spreadsheet to the user. I will have the excel spreadsheet available as a part of the website.

3) Is there a way to split RAD Grid into multiple rows? Currently I am able to achieve this behavior by using Master Detail view. But would like to know if this can be achieved directly using the Master view.

I will truly appreciate a prompt response. I am evaluating the asp.net ajax controls and these capabilities are must for our application. If there is no solution currently, would like like to know when can we expect these to be added.

Thanks in advance,
Navneet

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 01 Jul 2011, 08:35 AM
Hello Navneet,

Straight to your questions.

1. Check the following code library which explains excel like filter functionality.
Excel-like Auto-filter with RadGrid, RadMenu and RadAjax.

2. RadGrid supports exporting. You can find more about this in the following help article.
Overview.

3. I am not quite sure about your requirement. I suppose you want to show DetailTableView. If that is the requirement, you can achieve this by using NestedViewTemplate.

Thanks,
Princy.
Tags
Grid
Asked by
Navneet
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or