Decimal places when number format in excel

Question

Now decimal place is 2, I want to change it depending on variable, is it possible?

cell.v = parseFloat(cell.v),
cell.t = 'n';
cell.z = XLSX.SSF._table[2]; // 0.00 -> want to change to 0.000

Possible duplicate of [JavaScript displaying a float to 2 decimal places](http://stackoverflow.com/questions/3163070/javascript-displaying-a-float-to-2-decimal-places) — Rayon, Apr 08 '16 at 09:54
@RayonDabre it's not duplicate, it's about excel formatting, not just formatting number — karaxuna, Apr 08 '16 at 09:55

Bhojendra Rauniyar · Answer 1 · 2016-04-08T09:57:56.523

2

Just use .toFixed() method:

cell.z = Number(XLSX.SSF._table[2]).toFixed(3);//0.000

edited Apr 08 '16 at 09:57

answered Apr 08 '16 at 09:50

Value of `XLSX.SSF._table[2]` is `"0.00"`, so error is thrown `XLSX.SSF._table[2].toFixed is not a function`. I tried `cell.z = "0.000";` but it does not work. – karaxuna Apr 08 '16 at 09:53
First you need to convert it to the Number. Eg. Number("0.00").toFixed(3) – Bhojendra Rauniyar Apr 08 '16 at 09:56
Have you tested with xlsx-js? – karaxuna Apr 08 '16 at 11:01
Sorry. I don't have. What happens? – Bhojendra Rauniyar Apr 08 '16 at 11:02
Formatting is not applied at all. But thanks for trying to help – karaxuna Apr 08 '16 at 11:13
Bhojendra, what happens is that karaxuna has not correctly asked his question. I guessed the question and I replied. – Stéphane Laurent Feb 16 '17 at 20:21

Matthew · Answer 2 · 2016-04-08T10:24:12.340

2

Just use a combination of parseFloat() and toFixed():

cell.z = parseFloat(XLSX.SSF._table[2]).toFixed(3);

ParseFloat() is designed specifically to turn strings into numbers.

edited Apr 08 '16 at 10:24

answered Apr 08 '16 at 09:59

Matthew

score 1 · Answer 3 · answered Dec 27 '16 at 18:30

As I understand from the comments, the OP wants to write a XLSX file using the js-xlsx library, with a number rendered with 3 decimals.

I achieve this as follows. I add the format code "0.000" to XLSX.SSF._table:

XLSX.SSF._table[164] = '0.000'

Then cell.z = '0.000' should work.

I don't know why the index 164. If there is another format, it goes to 165, then 166, etc.

3 Answers3