Export Excel with pivot table using EasyXLS library! XLS, XLSX, XLSM, XLSB file in .NET.
https://www.easyxls.com/manual/tutorials/vb-net/create-excel-pivot-table.html