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

Export gridview to excel with filtering and sorting to be made available in Excel

2 Answers 41 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Keerthy
Top achievements
Rank 1
Keerthy asked on 05 Jan 2012, 07:54 AM
Hi,
      I have a requirement like, I am having a radgridview with data. I have the option of filtering and sorting the data in the radgridview.
Also, I can export the grid to excel.Before I export the grid to excel , I make certain modification before i view the data in excel file.Now I have to make the sorting and filtering available in the excel also by default. Is this possible? Kindly help me.


Thanks,
Keerthy.

2 Answers, 1 is accepted

Sort by
0
Dimitrina
Telerik team
answered on 05 Jan 2012, 09:50 AM
Hello Keerthy,

The GridView can export only to HTML (and save the output with xls extension) and ExcelML (supported from MS Excel 2003 and above version). 

To enable filtering and sorting for  the excel file itself, you should create your own excel file to export.

Greetings,
Didie
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Keerthy
Top achievements
Rank 1
answered on 05 Jan 2012, 10:54 AM
Hi Didie,
              That was helpful.Do you mean to say to enable sorting and filtering I have to use Excel Interop in silverlight?Do you have sample implementing the same?

Thanks,
Keerthy
Tags
GridView
Asked by
Keerthy
Top achievements
Rank 1
Answers by
Dimitrina
Telerik team
Keerthy
Top achievements
Rank 1
Share this question
or