jquery - Reading Excel file using SheetJs - Javascript - Stack Overflow

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);
    }
}

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);
    }
}

• javascript
• jquery

Share Improve this question Follow asked Oct 24, 2017 at 12:02 Noman AliNoman Ali 3,3401313 gold badges4747 silver badges7979 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 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];