Reading Excel file using SheetJs - Javascript

Question

I am trying to read Excel file using SheetJs

But getting following error.

Uncaught TypeError: Cannot read property '0' of undefined

Here is my file handler function

function handleFileSelect(evt) {
    //Get the files from Upload control
    var files = evt.target.files;
    var i, f;
    //Loop through files
    for (i = 0, f = files[i]; i != files.length; ++i) {
        var reader = new FileReader();
        var name = f.name;
        reader.onload = function (evt) {
            var data = evt.target.result;

            var result;
            /* convert from workbook to array of arrays */
            var first_worksheet = data.Sheets[data.SheetNames[0]];
            var data = XLSX.utils.sheet_to_json(first_worksheet, {header:1});
            alert(result[0].Column1);
        };
        reader.readAsArrayBuffer(f);
    }
}

gurvinder372 · Accepted Answer · 2017-10-24 12:11:02Z

10

You need to first read this data as an XLSX sheet first (Refer page 11)

workbook = XLSX.read(data, {type: 'binary'});

Followed by getting sheetnames from workbook (page 13)

var first_sheet_name = workbook.SheetNames[0];

answered Oct 24, 2017 at 12:11

gurvinder372

68.6k11 gold badges78 silver badges98 bronze badges

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

2 Comments

Noman Ali Over a year ago

Thanks, have any idea about It is converting large numbers like 3520000000000 into 3.52E+12 ?

gurvinder372 Over a year ago

@NomanAli Not sure, need to refer the docs for the same. I guess this is taking existing column setting from excel sheet. Probably create a new question for the same if this one has solved the problem you had originally described.

Collectives™ on Stack Overflow

Reading Excel file using SheetJs - Javascript

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related