i am trying to store several objects inside one big object to export to excel (file.xlsx) using alasql.js.
$scope.children=[{}];
var app = {
'a': $scope.children,
'b': $scope.name
};
$scope.name = [{
f: "aaa",
l: "bbb"
},
{
f: "ccc",
l: "dddd"
}];
$scope.childern is array of objects that contains children first and last name
$scope.confirm=function(){
alasql('SELECT * INTO XLSX("file.xlsx",{headers:true}) FROM ?', [app]);
}
user after filling out form and click confirm then output of this form should export to file.xlsx but it only show
a [object Object],[object Object]
b [object Object],[object Object]
inside file.xlsx