I've looked at the export to excel sample provided in your sample browser, but the sample code exports all rows/columns into excel even if they aren't visible. Is there any way to only export visible rows/columns(for example: if total rows were hidable)?
Bump.
The tricky part here seems to be the row and column headers and adjusting their positions/cell merging. Since the placement of the actual cells with data is them is easy.
Hello Ryan,
Thank you for post. I have been looking into your question and the sample application for exporting the XamPivotGrid to excel is exporting the current view of the control. It is exporting the same data that is visible in the XamPivotGrid. I am attaching a sample application that is showing how the approach is implemented.
The sample is using Infragistics Excel Engine and you can use it as bases and modify it based on your needs. You can read more details on the Excel Engine here: http://help.infragistics.com/Doc/WPF/current/CLR4.0/?page=WPF_Infragistics_Excel_Engine.html.
Please let me know if you need any further assistance on the matter.
Sincerely,
Krasimir, MCPD
Developer Support Supervisor - XAML
Infragistics
www.infragistics.com/support