Hi!
I've tried the silverlight excel export sample and it works fine if there's only one page. However when there's more than one page in the xamGrid then it exports the current one since the xamGrid.Rows collection only has the current row set for the page. Is there a way to get all of the rows from all of the pages? I've tried it with ItemsSource, but that only contains the objects that are being bound and not the actual rows. I also need to think about the grouping functionality which will only complicate matters more if i try it with the ItemsSource.
Thanks!
You would have to turn off paging prior to the export so that the grid will have all the rows in it.
I'm sorry, but that is an unacceptable solution. The paging needs to be turned on because i'm dealing with a lot of data.
The Grid will only have the Rows it needs for the page so if you have paging turned on so your options would be to either
1) Export from the DataSource directly
2) Turn off paging which will allow the grid to see all the available data and make rows for it, export, turn paging back on.
When we export it from DataSource, filtering, sorting options are not reflected in result.
When we turn off paging before export, user recognizes that we change it which is not user friendly.
Any other ideas?