U need to ask ur backend to give it u as astring as this is js limitation. I did the same long back.
Regards, Charul On Wednesday, August 8, 2018, vishnu siddareddy <[email protected]> wrote: > 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. > -- 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.
