Click here to Skip to main content
15,867,488 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
HI all

i am exporting a gridview to excel which have paging on the web form but on excel it shows all the records without paging. (i know this is the right behaviour) but what client want is to use paging in excel also. is there any way we can manage this.
Posted

1 solution

Probably, yes - but I've not tried, and it's probably a lot of work.
There are Forms available in Excel: http://office.microsoft.com/en-gb/excel-help/overview-of-forms-form-controls-and-activex-controls-on-a-worksheet-HA010342745.aspx[^] which might be able to do it, but I've not tried.

Personally, I'd do something like that either in an external report, or in a different language entirely - probably C# or VB...
 
Share this answer
 
Comments
ravikhoda 27-Feb-14 4:09am    
thanks , but yes you are right there will be a lot of play around don't want to go this way :D

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900