asked on May 1, 2016
Flexmonster Grid Export to Excel, the excel output has a tab name called "Flexmonster Pivot Table"
Is there a way to change it? jsfiddle example please.
Also I dont know if it is a bug, but when I try to export to image or pdf (from both grid and graph), it didn't capture all the tables.
⋅ May 2, 2016
Hi!
Please use the following syntax
flexmonster.exportTo('Excel', {filename : 'flexmonster.xlsx', excelSheetName: 'My Excel'});
Does it work?
⋅ May 2, 2016
where do I put this code?
⋅ May 2, 2016
If you want to change the default behaviour please open flexmonster.toolbar.js and modify line 302 like following:
self.exportHandler = function(type) {
if (type == "excel") {
flexmonster.exportTo('Excel', {filename : 'export.xlsx', excelSheetName: 'Sheet 1'});
} else {
(type == "pdf") ? self.showExportPdfDialog() : self.pivot.exportTo(type);
}
}
Please feel free to modify toolbar. js and toolbar.css files
⋅ May 2, 2016
still not working
⋅ May 2, 2016
Please download working sample from here: https://s3.amazonaws.com/flexmonster/komsystems/FLEXMONSTER-2016-KOMSYSTEMS-MAY2.ZIP
⋅ May 2, 2016
thanks. Any response on why if I export to img, it didn't captchure everything?
⋅ May 2, 2016
Sorry, it's not possible in the current version. You can export only visible part of the grid. I hope we will improve this functionality in the future releases.
