Is it possible to get and MODIFY PageFieldSettings?

Sep 5, 2014 at 7:54 AM
Hello.

I have a xlsx file with pivotal tables. Some tables have filters (page fields), I need to find all the filters and if they match with the one passed to method - change the settings, for example: I have page field “CompanyId” and if I call my method like:

void ChangeFilter(“CompanyId”,100);

I would expect that filter selects 100

I’m trying EPPlus (4.0 beta - the stable version didn’t want to open my xlsx), and while I can find find the table filters, I can’t change the PageFieldSettings since it’s read only... is there any other way to manipulate filters, or is it simply not supported feature?

Thanks in advance.

Best regards.