Hi, Change data type of your big number as string and not number, should resolve the issue
Regards, Charul On Wednesday, August 8, 2018, vishnu siddareddy <[email protected]> wrote: > I am using Angular2Csv library for upload JSON data to CSV form. But the > big number is showing in exponential format in excel sheet. > > Number 3530123456789010 becomes like, 3.53012E+15 > > Is there any solution to avoid that? > > > exportToCSV = function (dataobj) { const options = { > fieldSeparator: ',', > quoteStrings: '"', > decimalseparator: '.', > showLabels: true, > showTitle: true, > headers: Object.keys(dataobj.data[0]) > }; > // console.log(JSON.stringify(data)); > new Angular2Csv(dataobj.data, 'My Report', options);} > > > > -- > You received this message because you are subscribed to the Google Groups > "Angular and AngularJS discussion" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/angular. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/angular. For more options, visit https://groups.google.com/d/optout.
