Given that igPivotView is made up of an igPivotGrid which in turn uses an igGrid to render the OLAP data I was hoping to use the $.ig.GridExcelExporter to export the data.
Unfortunately I've not found the right combination of code to do so.
I was hoping that something like this would work:
var pivotGrid = $(#pivotView").igPivotView("pivotGrid");
var grid = $(pivotGrid).igPivotGrid("grid");
$.ig.GridExcelExporter.exportGrid($(grid), { fileName: "igGrid" });
However the error I receive is "cannot call methods on igPivotGrid prior to initialization; attempted to call method 'grid'"
Can anyone help?
Hello David,
Unfortunately you cannot use $.ig.GridExcelExporter to export the igPivotGrid.However you can export it with some custom code. I'm attaching a sample demonstrating export to Excel of an igPivotGrid.If you want this feature to be included as part of the product you can vote for the following product idea on our site: http://ideas.infragistics.com/forums/211535-ignite-ui/suggestions/5133617-export-of-pivot-grid-into-excel-pdf-word.
Hope this helps,Martin PavlovInfragistics, Inc.
I forgot to say that I am working in C#.Any examples?
Hi Martin
I am trying to achieve this too. Could you send me that "custom code" you talk about?
Thanks