I don't know what a "pivot table" is exactly, but it sounds like you want Spreadsheet::WriteExcel for the output.