blog.syncfusion.com
Syncfusion XlsIO and Excel PivotTables
Please take a look at this quick video showing how XlsIO can be used to update and create PivotTable in an Excel workbook.