asked on September 12, 2017
Hi
I have been asked to display a title on the reports, when the data is exported to Excel. Currently, only the pivot table data is shown, but no title or date is displayed.
Is there any chance to add some static data to the Excel file, when exported?
⋅ September 13, 2017
Hello Alberto,
Thank you for writing.
Please try adding the title to your report. You can set the title you want and it will be exported to the Excel file. Check the example on JSFiddle that shows how to set grid title: http://jsfiddle.net/flexmonster/afr1g5Lf/.
Does it work for you?
Regards,
Tanya
⋅ September 14, 2017
Dear Tanya,
This is very useful. However, it would be even better if I could set the title in the report static definition, without having to use the button. Is there any chance to set it in the following structures?
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
toolbar: true,
report: {
dataSource: {
data: getData()
},
slice: {
... }
});
⋅ September 14, 2017
Hello Alberto,
Sure, you can define the title in the report configuration.
Please use options.grid.title property for that.
Let me know if you have any further questions.
Regards,
Ian
