Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Grid > Grab excel export data from grid

• stian.net

  Posted on Feb 9, 2012 (permalink)

  I'm using RadGrid (RadGrid.Net2 (I know I should upgrade to a newer version, but that is not an option here..)). One of it's features is to export data to excel. Withgrid.MasterTableView.ExportToExcel(); an excel file is created with filtered and sorted data from the grid (all pages). How can i grab this data?

  grd.ExportSettings.ExportOnlyData = true;
  grd.ExportSettings.IgnorePaging = true;
  grd.MasterTableView.ExportToExcel();
  

  I want to grab the same data as the grid is writing to excel but can't figure out how to do this..

  grd.MasterTableView.GetExportDataAsDataTable() would be perfect ;)

  Reply

• Daniel Daniel

  Posted on Feb 14, 2012 (permalink)

  Hi Stian,
  
  It is not possible to directly generate a dataset (or any other data container) from the exported data. Of course, you could implement this functionality on your own. Rebind the control, traverse all rows and fill your dataset manually from the table cells, ignoring all the unwanted data.
  
  Regards,
  Daniel
  the Telerik team

  Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Grid > Grab excel export data from grid