Refresh Pivot Tables using EPPlus

Jan 6, 2015 at 12:11 PM

I have a multiple pivot tables per worksheet (multiple worksheets) in one excel file. The sources of the pivot tables are hidden worksheets. Is there any way to refresh all pivot tables using EPPlus?
Actually I need to refresh pivot tables and delete hidden worksheets inside the excel file situated on my server(where I don't want excel to be installed). Deletion of the worksheets is trivial but couldn't find anywhere if it's possible to refresh pivot tables and how.