ember-cli-data-export
Addon that encapsulates ability to render a data set as either excel or csv.Installation
- ember install ember-cli-data-exportUsage
- 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
```javascriptvar 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'});
}
```