But the value is coming from server. Can u please tell where I can able change the type?
On Wed, Aug 8, 2018, 7:42 PM Charul Chavda <[email protected]> wrote: > 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. > -- 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.
