Can I use DataPresenterExcelExporter with a XamPivotGrid?
If so please provide a brief instruction,
If not, what is the recommended way to export from a pivot grid?
Thanks very much,
Sam
Hello Sam,
I have created a sample application for you, which demonstrates how you can export the XamPivotGrid in a MS Excel document using NetAdvantage for WPF Data Visualization 11.1. I have tested the sample application that I am attaching with both, the RTM version (11.1.20111.1004) and the latest Service Release (11.1.20111.2173) and it seems to work as expected.
Please let me know if are getting the same behavior, while exporting the XamPivotGrid to Excel, using the sample application that I have attached.
Looking forward to hearing from you.
Sincerely,
Krasimir
Developer Support Engineer
Infragistics
www.infragistics.com/support
Hi Stefan,
Thank you for your reply. We are using version 11.1 of the controls and unfortunately we cannot move to 11.2. The code you postedt looks the same as what I am using. The code crashes here:
if
(ColumnSpan > 1 || RowSpan > 1)
SheetOne.MergedCellsRegions.Add(RowId, ColumnId, RowId + RowSpan - 1, ColumnId + ColumnSpan - 1);
Thank you for your post. I have been looking into it and I can say that you are not able to use the DataPresenterExcelExporter, but I suggest you see this forum thread:
http://blogs.infragistics.com/forums/p/64339/325574.aspx
where there is a sample of exporting XamPivotGrid to Excel. Also you can find a sample in the Feature Browser under XamPivotGrid / Scenarios / Export to Excel section. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.