I'm using RadGrid from Telerik (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. With grid.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 Telerik is writing to excel but can't figure out how to do this..
grd.MasterTableView.GetExportDataAsDataTable()
would be perfect ;)