moilopez/ember-cli-data-export

Addon that encapsulates ability to render a data set as either excel or csv.

ember-cli-data-export

Addon that encapsulates ability to render a data set as either excel or csv.

Installation

• ember install ember-cli-data-export

Usage

• uses js-xlsx library for rendering excel content.
• automatically injects a service for both excel and csv format
• feed a datastructure that's an array of arrays, where each internal array is the set of data to be rendered for that row.
• Example: [['Title 1', 'Title 2', 'Title 3'],['row1cell1', 'row1cell2', 'row1cell3'],['row2cell1', 'row2cell2', 'row2cell3']]

Example

   var data = [
       ['Title 1', 'Title 2', 'Title 3'],
       ['row1cell1', 'row1cell2', 'row1cell3'],
       ['row2cell1', 'row2cell2', 'row2cell3']
   ];

   if (type === 'Excel') {
     this.get('excel').export(data, {sheetName: 'sheet1', fileName: 'test.xlsx'});
   } else if (type === 'CSV') {
     this.get('csv').export(data, {fileName: 'test.csv'});
   }