how to assign json.stringify() to javascript variable

Question

Here in this code, i want to achieve to calculate the sum of particular data that i took from excel file by this line :

 " sumofKoli += JSON.stringify(row.values[4]);".

My problem is that even this line of code :

console.log(JSON.stringify(row.values[3])+" Sold number of :"+ JSON.stringify(row.values[4]));

Gives what i want like "47" which i exactly want as an integer, when i try to sum all the data i am having a result which is like "94559129995555.5.2556149.9". It adds it as a string value, i want it to sum as integer. Can you help me ?

Here is the full code :

Reader.prototype.readExcel = function(chartType,callback){


  // read from a file
  var workbook = new Excel.Workbook();
  var sumofKoli=0;
  var sumPrice =0;
  workbook.xlsx.readFile(filename)
      .then(function(err,results) {
          var worksheet = workbook.getWorksheet('Sayfa1');
          worksheet.eachRow({ includeEmpty: true }, function(row, rowNumber) {
            console.log("----------");
            console.log(JSON.stringify(row.values[3])+" Sold number of :"+ JSON.stringify(row.values[4]));
            console.log("----------");
            sumofKoli += JSON.stringify(row.values[4]);
            console.log(JSON.stringify(row.values[3])+" Sold in price of  :"+ JSON.stringify(row.values[5]));
            sumPrice += JSON.stringify(row.values[5]);
            console.log("----------");

          });
          results = { sumofKoli : sumofKoli, sumTutar : sumPrice};
          if (err){callback(err,null);}

          callback(null,results);
      });

You are trying to add variable of type string with variable of type integer. — Mukesh Sharma
– Mukesh Sharma, Commented Jan 24, 2017 at 15:26

Vladu Ionut · Accepted Answer · 2017-01-24 15:27:02Z

1

You have to use parseInt to convert the string to Number

sumofKoli += parseInt(JSON.stringify(row.values[4]));

edited Jan 24, 2017 at 15:27

answered Jan 24, 2017 at 15:25

Vladu Ionut

8,2231 gold badge23 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Brian H. Over a year ago

he specifically said he wants an Integer though

ozer Over a year ago

thank you all for your answers but it returns NaN when i try : sumPrice += parseFloat(JSON.stringify(row.values[5])); sumPrice += parseFloat(JSON.stringify(row.values[5])); both solutions return "NaN" value.

Vladu Ionut Over a year ago

can you give us the data within the row object

ozer Over a year ago

Okay, NaN was the result of blocks. Now, i am able to get the sum of the row data. thank you so much !

Thomas Over a year ago

why would one stringify a number just to immediately parse it back to a Number? how about: sumofKoli += Math.floor(row.values[4])

Antony · Accepted Answer · 2017-01-24 15:26:01Z

0

Convert your json'd values to integers with the parseInt (or parseFloat if you have decimals) functions when trying to sum them.

As your values are currently considered strings, it currently concatenate them instead of adding them.

answered Jan 24, 2017 at 15:26

Antony

1,27311 silver badges19 bronze badges

Comments

Ritik Saxena · Accepted Answer · 2017-01-24 15:27:51Z

0

If your data is only integer, then use parseInt instead of JSON.stringify while adding. In case you have float values too, use parseFloat. Syntax is simple:

sumofKoli += parseInt(row.values[index])

answered Jan 24, 2017 at 15:27

Ritik Saxena

7241 gold badge13 silver badges26 bronze badges

Comments

Marc Carné Bori · Accepted Answer · 2017-01-24 15:32:55Z

0

OP is asking to sum integers, so similar to Vladu Ionut's answer it should be:

sumofKoli += parseInt(JSON.stringify(row.values[4]));

But, why are you stringigying a JSON and then parsing it? Why not use the value directly?

sumofKoli += parseInt(row.values[4]);

It seems odd to stringify something just to cast it afterwards.

answered Jan 24, 2017 at 15:32

Marc Carné Bori

663 bronze badges

Collectives™ on Stack Overflow

how to assign json.stringify() to javascript variable

4 Answers 4

5 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related