CODEWITHSUNDEEP
javascriptjquery
Noman Ali
Noman Ali

Reputation: 3340

Reading Excel file using SheetJs - Javascript

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

Upvotes: 5

Views: 18923

Answers (1)

gurvinder372
gurvinder372

Reputation: 68363

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];

Upvotes: 10

Related Questions