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