mongo-xlsx icon indicating copy to clipboard operation
mongo-xlsx copied to clipboard

Convert array of objects in different excel sheet in one excel

Open user1702 opened this issue 6 years ago • 0 comments

Using below code, not able to convert the data into one excel with mutiple sheets. I am getting all data in one sheet.

var  jsonXlsx = [[{ "Name": "Eddie", "Email": "edward@mail" }], [{ "Name": "Nico", "Email": "nicolas@mail" }]] ;
const sheets = ['a','b'];
var excelPageData = [];
/* Generate automatic model for processing (A static model should be used) */
var model = mongoXlsx.buildDynamicModel(jsonXlsx);

/* Generate Excel */
  excelPageData.push(mongoXlsx.mongoData2XlsxData(jsonXlsx, model));
  mongoXlsx.mongoData2XlsxMultiPage(excelPageData, sheets, function(err, data) {
	console.log(err)
  console.log('File saved at:', data.fullPath); 
  });

user1702 avatar Dec 17 '18 06:12 user1702