Open Pivot on excel when exporting

samsamtest

Hi
I wonder, dose any one now when we export to excel, how we can create a empty pivot that we export to excel?

I have attached images what I mean.
Kinde Regards Sam

samsamtest

Any one pleas help

allan

Hi Sam,

I’m afraid that is beyond what our Excel export can do, unless you want to modify the XML that it creates with the required information in it (you’d need to look up the open spreadsheet specification for that - I don’t know off the top of my head I’m afraid).

To use the more advanced features of Excel, you’d probably be better using ExcelJS or similar to create your own spreadsheet from the data in the DataTable.

Allan