Menu
Download Free Trial

Export Question and Bug

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.

7 answers

Public
Roman Petrusha Flexmonster May 2, 2016

Hi!

Please use the following syntax
flexmonster.exportTo(‘Excel’, {filename : ‘flexmonster.xlsx’, excelSheetName: ‘My Excel’});
Does it work?

Public
David Chen May 2, 2016

where do I put this code?

Public
Roman Petrusha Flexmonster 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

Public
David Chen May 2, 2016

still not working 

Public
Roman Petrusha Flexmonster May 2, 2016

 Please download working sample from here: https://s3.amazonaws.com/flexmonster/komsystems/FLEXMONSTER-2016-KOMSYSTEMS-MAY2.ZIP

Public
David Chen May 2, 2016

thanks. Any response on why if I export to img, it didn’t captchure everything? 

Public
Roman Petrusha Flexmonster 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.

Please login or Register to Submit Answer