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

Import not comming properly

Open syampsijk opened this issue 7 years ago • 0 comments

My exported data is not comming in order,its coming a single character in a column

data.collection("Points”).find({'businessId': ‘shopname’ ,’_created_at':{$gt:d}}, { _id: false}).toArray(function(err, result) {

for(f=0;f<result.length;f++) { data = '{'+" Shop : ""+result[f].businessname+"", Points : "+result[f].point+'}'; data = data+" , " +data; }

//data export data = [data]; data = data.replace(/'/g, ''); var model = mongoXlsx.buildDynamicModel(data); mongoXlsx.mongoData2Xlsx(data, model, function(err, data) { console.log('File saved at:', data.fullPath); });

This is what i am doing but i guess my data comes as ['{shop : "shopname",Points : 10 }']; Please help .i tried replace function but its not working . Or is it any other issue,

syampsijk avatar Jan 14 '18 12:01 syampsijk