This project has moved and is read-only. For the latest updates, please go here.


Jul 19, 2011 at 11:36 PM
Edited Jul 20, 2011 at 12:02 AM

Hello, can you tell me please as adding a filter in one of the fields in a PivotTable (Report / Filter)

This line of code is Sample12.cs:


//Add a page field                

var pageField = pivotTable2.PageFields.Add(pivotTable2.Fields["Title"]);

I would like to add a filter on that field so that when I generated the excel display the selected (show the one selected and not (ALL) in the excel)

Jul 22, 2011 at 5:20 PM
Edited Aug 2, 2011 at 11:40 PM

Hello can you help me with this please I would greatly appreciate thanks .

Aug 2, 2011 at 11:46 PM

Select Multiple one or Items in filter PivotTable

Help please.

Aug 7, 2011 at 6:58 PM
Edited Aug 7, 2011 at 7:00 PM

I would like help with this too. 

Is it possible? If so can someone please point to an example or just a code snippet?

If not, is there a work around?


Thank you.


Edit: BTW great tool so far. I'm new to C# coding and excel too but this has helped me learn a lot. 

Aug 9, 2011 at 1:51 PM


There is no way to do that in the current version. EPPlus relays on Excel to create all the data in the pivottable, so at creation time there are no "items" in the the pivottable.