EPPlus: dynamic pivot table using external connection

May 9 at 8:54 AM
I read that EPPlus is supporting pivot tables, but I would need something like the Excel.interop property PivotTable.SourceData, to generate a dynamic sheet which updates its data using the given connection.
Is this feature available in EPPlus? Or could you please help me in setting up an external connection on a pivot object? I've written a 'create connection' method using pure OpenXML but I'm having some difficulties in associating this connection to a pivot...