Create An Export to CSV/Excel Tool for Grid Views

Eugene_Rack

Thanx for the update. I will have to upgrade I think.

R_Delawder

I added this to my test environment and it works nice. (had to add a file name to the PDF option)

Do you have a way to get this to work on the search screen?

Olena_Prychyna

Seems like we cannot make it to work with views created from SQL Table Widget.
The page has an advanced grid (type=AdvancedChartGrid) without a toolbar.
I tried to add a toolbar with the button:

 

var divDroptarget = $('[data-role=droptarget]');    
$(divDroptarget).before("<div class='k-header k-grid-toolbar'><a class='k-button k-button-icontext k-grid-excel' href='#'><span class='k-icon k-i-excel'></span>Export to Excel</a></div>"); 

then set the options:

$(this).data('kendoGrid').options.excel={fileName:"CiresonPortal.xlsx", allPages:true, proxyURL: ""};

But when you click the button – nothing happening. Any suggestions?
Our portal version 7.1.2012.0

Olena_Prychyna

Proper way to add a toolbar to an existing grid:

$('[data-role=grid]').each(function (index){     

 if($(this).data('kendoGrid').options.toolbar == null){
      //there is no toolbar in dashboard grid - add a toolbar with button
     var grid = $(this).data('kendoGrid');
     grid.setOptions({
      toolbar:
       [{template:
        '<a class="k-button k-button-icontext k-grid-excel" href="\\#"><span class="k-icon k-i-excel"></span>Export to Excel</a>'
       }]
     });
     }

$(this).data('kendoGrid').options.excel={fileName:"CiresonPortal.xlsx", allPages:true, proxyURL: ""};

});

Then export to excel for dashboard view grid will work .

Brent_Faul1

I have added the code to my custom.js file in QA, but don't see any update at all?  I should see additional buttons correct?

I am running portal version 7.4.2012.3, have verified that \Content\Kendo\2016.1.226 & \Scripts\kendo\2016.1.226 folders are available.  I have also cleared my local browser cache, restarted the website, restarted cache builder service, and reset several search views.

Brent_Faul1

I tried the latest version from Roland and the buttons show up now.  I was hoping this would be useable with the search views, but still really nice addition.