samedi 3 février 2018

How to generate multiple sheets in one excel file using ember-cli-data-export

I am able to generate one sheet only with the ember-cli-data-export through the following javascript function of:

this.get('excel').export(data, {sheetName: 'Overview', fileName: 'test.xlsx'});

I have tried the following way (below) to generate multiple sheets but it is not working.

this.get('excel').export([data1, data2], {sheetName: ['Overview', ,Next'], fileName: 'test.xlsx'});

How do I generate multiple sheets in one excel file test.xlsx using ember-cli-export?




Aucun commentaire:

Enregistrer un commentaire