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

Export To Excel with Server side paging applied

3 Answers 73 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Harsh
Top achievements
Rank 1
Harsh asked on 08 Apr 2011, 10:55 PM
Hi,

I have applied server side paging in my application.I want to export data to excel.
But due to paging at any point of time i do have one page data only not the complete set.
How i can export whole data to excel.

Regards,
Harsh

3 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 11 Apr 2011, 07:12 AM
Hi Harsh,

 Why not use Telerik Reporting to export the data server-side and download the result? 

Best wishes,
Vlad
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Harsh
Top achievements
Rank 1
answered on 12 Apr 2011, 03:40 AM
Thanks Vlad .

I am not clear how i will be doing that.I saw some of the reporting services sample but it was not clear to me after that as well.
I don't want to redirect user to any other page to export the data.The samples which i saw those were having some kind of
UI to export data.
I tried to install Reporting service sample app on my desktop but was not able to do so beacuse it was looking for SQL server installation which i am not having.

Please guide me to some link or sample program which can help me to figure this issue out.

Thanks in Advance.
Harsh
0
Steve
Telerik team
answered on 12 Apr 2011, 04:19 PM
Hello Harsh,

I cannot comment on the GridView's export to Excel and how it works, but the Reporting tool is not a generic exporting tool. A report is a template following strict rules for layout and pagination and meant for generating documents.

All Telerik Reporting output formats have specific characteristics that determine their usage and impose ceratin limitations, which need to be taken into consideration when designing reports.

The following rendering extension categorization shows how extensions vary:

  • Data rendering extensions: CSV
  • Logical page layout rendering extensions: HTML, Excel
  • Physical page layout rendering extensions: Image, PDF, RTF, XPS, PPTX, DOCX

The logical layout formats (HTML, Excel) are best suited for viewing and manipulating data, while the physical layout formats are intended for precise printing.

Having the above in mind, the Excel format does not offer physical pages and cannot follow any rules applicable for page oriented formats, so you would not be able to apply any custom paging. More information on the Excel format is available in the Design Considerations for Excel Rendering help article.
Another article that would be useful in your case: Exporting Report in Silverlight.

Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
GridView
Asked by
Harsh
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Harsh
Top achievements
Rank 1
Steve
Telerik team
Share this question
or