I am exporting data to excel and PDF formats.I am able to add custom headers and footers to PDF.Is the same possible in Excel?
If not is there something similar to what I need?
Hello, Sudharsan,
Thank you for your question.
We would like to confirm that it is possible to add custom fields to be displayed in the Excel export.
This can be done by defining the customFields
property in your report, for example:
customFields: [
{
name:"Field1",
value:"Value1"
},
{
name:"Field2",
value:"Value2"
}
]
Here is a JSFiddle example for illustration.
Also, we would like to bring to your attention that you can also set a title which will be included in the export as well.
The title can be set in the options
object, for example:
options: {
grid: {
title: "Results"
}
}
In this JSFiddle example, you can see that the set title is present in the export file.
Please let us know if this works fine for you.
Best Regards,
Vera