ember-spreadsheet-export

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

Forked from roofstock/ember-cli-data-export.

Differences from `ember-cli-data-export` include:

Dependencies have been updated to address various deprecations
The undocumented export-selector and export-selector-onselect components have been removed, in order to remove the dependency on ember-select-list, which hasn't been updated in a long time
The csv and excel services are not automatically injected
The dummy app now has content (a couple of buttons to generate demo files)
Multiple sheets can be added to a single XLSX file
[v0.3.0] The excel service supports merging cells via an additional merges option

Installation

ember install ember-spreadsheet-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']]

Merging Cells (Excel only)

In order to merge cells, an array of merges can be passed in the options hash. Each element of this array should be an object taking the following form:

{
  s: {
    r: 0,
    c: 0,
  },
  e: {
    r: 1,
    c: 0,
  },
}

s defines the start of the range to be merged, and e the end of the range. Within each, r is the row index and c is the column index. The example above would therefore merge the first two cells in the first column.

Examples

   // Don't forget to inject the service(s) as needed
   csv: service(),
   excel: service(),
   
   // Then go ahead and use it in your code
   let data = [
       ['Title 1', 'Title 2', 'Title 3'],
       ['row1cell1', 'row1cell2', 'row1cell3'],
       ['row2cell1', 'row2cell2', 'row2cell3']
   ];

   if (type === 'MultiExcel') {
     let sheets = [
       {
         name: 'Demo sheet',
         data
       },
       {
         name: 'Supplemental sheet',
         data: [
           ['Foo', 'Bar'],
           ['Baz', 'Foobar']
         ]
       }
     ];
     this.excel.export(sheets, {multiSheet: true, fileName: 'test.xlsx'});
   } else if (type === 'Excel') {
     this.excel.export(data, {sheetName: 'sheet1', fileName: 'test.xlsx'});
   } else if (type === 'CSV') {
     this.csv.export(data, {fileName: 'test.csv'});
   }