I'm using the pivot table and have successfully used the Export to Excel functionality.
However, I would want to heavily customise this export. For instance I want to:
set format some of the cells to currency/number/date format
set font styling such as bold/highlight/underline etc
Is something like this possible using the standard export to Excel functionality? If not, what other options are there?
Alternatively, is it possible to send the processed pivot data back to my server? My server would then be able to generate the Excel file with the required formatting, but I'm hoping there is an easier way?