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
Any one pleas help
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.
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.