Is it possible to add headers and footers while exporting to excel?

Sudharsan asked on June 14, 2019

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?

1 answer

Public
Vera Didenko Flexmonster June 14, 2019

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

Please login or Register to Submit Answer