Scientific notation mobile number - Excel Javascript

Question

I am reading excel file in my JS App. I am using xlsx npm module to read excel file.

But if MobileNumber in file = 9.23052E+8 then how can i convert it back into plain mobile number in javascript?

Here is example code of how i am reading file:

const bstr = evt.target.result;
const wb = XLSX.read(bstr, {type:'binary'});
const wsname = wb.SheetNames[0];
const ws = wb.Sheets[wsname];
const data = XLSX.utils.sheet_to_csv(ws, {header:1});
console.log("Data>>>"+data);

I don't want to tell user to change format of your cells to plain text or numbers. (Sorry but that is a requirement).

Any help would be appreciated.

Can't you change the excel file's cell display settings before reading in the file? Because Excel just saves the raw data, and display's it in this format based on the settings of the cell. — Luuklag
– Luuklag, Commented Dec 5, 2017 at 11:09

Noman Ali · Accepted Answer · 2017-12-05 11:39:05Z

0

This code resolved my issue:

Object.keys(sheet).forEach(function(s) {
    if(sheet[s].w) {
        delete sheet[s].w;
        sheet[s].z = '0';
    }
});

Collectives™ on Stack Overflow

Scientific notation mobile number - Excel Javascript

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related