How to create a pivot table from collection data or excel's data

[Anonymous]

Hi,  I've a requirement of creating a pivot table from a data stored into collection or excel. Does anybody knows it how to achieve this?

[John__Carter]

The simplest option is to manually create a template Excel file with 2 sheets, one containing the pivot and one for the data. Create the pivot manually with some test data and save the template. Then have BP open the template, overwrite in the data and save a copy of the file. The Excel VBO does not have any 'create pivot' actions, you would need to create them. And given that there are many settings to a pivot table, this would not be an easy job.

[LucyLu]

So for any process related to pivot, is it easier to just navigate on the Excel UI?

[John__Carter]

Probably not, although I have never tried. I think using a pre-made template is the easiest but that approach may not suit every project.