AngularJS ng-grid Export to Excel for selectedItems

Question

We have a ng-grid which displays data retrieved from a rest service. I want to export the rows selected by user(ng-grid selection check box enabled) to an excel and open that excel. The current behavior of app is Export to excel button calling a rest service with selected items from ng-grid and using POI to put the data into excel and returning the excel.

Is there a better way to do this? The data is already in browser, is there any angularjs, jQuery or javascript function to do this?

Maybe this topic can help

Nikos Paraskevopoulos
– Nikos Paraskevopoulos

2013-10-09 06:57:34 +00:00
Commented Oct 9, 2013 at 6:57 — Nikos Paraskevopoulos
– Nikos Paraskevopoulos, Commented Oct 9, 2013 at 6:57

AardVark71 · Accepted Answer · 2013-10-09 08:43:32Z

5

There is a plugin for csv export : https://github.com/angular-ui/ng-grid/tree/master/plugins

It can be easily added by adding it to your gridoptions, while making sure to display the footer.

 $scope.gridOptions = {
        data: ...,
        plugins: [new ngGridCsvExportPlugin()],
        showFooter: true,
        ...
      };

It exports all your records from your specified grid.data.

[Although you can pass in an options object for specifying columns etc. there isn't an option currently to limit to selectedItems.]

It looks easy though to adjust the ng-grid-csv-export.js source to loop over grid.mySelections instead over grid.data. (not tested by me yet)

answered Oct 9, 2013 at 8:43

AardVark71

4,1042 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ayan Over a year ago

Looks easy to change the data to grid.mySelections, will try it. but How should I move that csv data to excel now in javaScript.

lostpacket Over a year ago

You can copy text to the user's clipboard and ask user to paste it in Excel. The values should be tab delimited.

sms Over a year ago

The link is not available now. can you provide needed help?

AardVark71 Over a year ago

@sms the plugin is still available on some of forked repos. Such as this one : github.com/choroshin/ng-grid/tree/master/plugins

Collectives™ on Stack Overflow

AngularJS ng-grid Export to Excel for selectedItems

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related