Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Praba
200
Need Help in exporting object to Excel
posted

My application uses UltraWebGridExcelExporter to export the ultrawebgrid to excel.

But I have to export first 500 records from the data source where as the ulrawebgrid just displays first 25 records due to pagination.

So only 25 records are exported by UltraWebGridExcelExporter to excel.

Is there any way to export 500 records to excel using UltraWebGridExcelExporter or is there any other approach to export to excel?

Your help is greatly appreciated.

 

Thanks,

Praba

  • 140
    posted

    I'm not sure if there is a better way to do this, but whenever I have had this problem in the past I solved it in any of the following ways:

    1. When you start the export routine, remove paging, rebind the data, export, add paging and rebind the data.

    2. Use a second invisible non-paged grid and export that.

    3. Just use a dataset, convert it to an excel document and push that to the user instead.