How to read excel file in angularjs?

I have tried to read excel file to follow the following tutorial.
http://code.psjinx.com/xlsx.js/
But I have failed to read excel file for undefine situation in the following highlighted line.... I have tried it in IE11.

var reader = new FileReader();



            reader.onload = function(e) {

                var data = e.target.result;

                var workbook = XLSX.read(data, {

                    type: 'binary'

                });



                obj.sheets = XLSXReader.utils.parseWorkbook(workbook, readCells, toJSON);

                handler(obj);

            }



            **reader.readAsBinaryString(file)**;

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

Could you specify: are you going to upload your Excel file from desktop or load from server?

– agershun
Dec 22 '14 at 15:11

add a comment |

var reader = new FileReader();



            reader.onload = function(e) {

                var data = e.target.result;

                var workbook = XLSX.read(data, {

                    type: 'binary'

                });



                obj.sheets = XLSXReader.utils.parseWorkbook(workbook, readCells, toJSON);

                handler(obj);

            }



            **reader.readAsBinaryString(file)**;

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

Could you specify: are you going to upload your Excel file from desktop or load from server?

– agershun
Dec 22 '14 at 15:11

add a comment |

var reader = new FileReader();



            reader.onload = function(e) {

                var data = e.target.result;

                var workbook = XLSX.read(data, {

                    type: 'binary'

                });



                obj.sheets = XLSXReader.utils.parseWorkbook(workbook, readCells, toJSON);

                handler(obj);

            }



            **reader.readAsBinaryString(file)**;

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

var reader = new FileReader();



            reader.onload = function(e) {

                var data = e.target.result;

                var workbook = XLSX.read(data, {

                    type: 'binary'

                });



                obj.sheets = XLSXReader.utils.parseWorkbook(workbook, readCells, toJSON);

                handler(obj);

            }



            **reader.readAsBinaryString(file)**;

javascript angularjs excel

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

asked Dec 17 '14 at 10:27

Amin Uddin

46241327

Could you specify: are you going to upload your Excel file from desktop or load from server?

– agershun
Dec 22 '14 at 15:11

add a comment |

Could you specify: are you going to upload your Excel file from desktop or load from server?

– agershun
Dec 22 '14 at 15:11

Could you specify: are you going to upload your Excel file from desktop or load from server?

– agershun
Dec 22 '14 at 15:11

add a comment |

1 Answer
1

active

oldest

votes

-1

The following answer describe, if you are going to load xlsx file from server. For uploading there is another code.

OPTION 1: This is a procedure, which works in Alasql library:

See files: 15utility.js and 84from.js for example

readBinaryFile(filename,true,function(a){

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

    // do what you need with parsed xlsx

});



// Read Binary reading procedure

// path - path to the file

// asy - true - async / false - sync



var readBinaryFile = utils.loadBinaryFile = function(path, asy, success, error) {

    if(typeof exports == 'object') {

        // For Node.js

        var fs = require('fs');

        var data = fs.readFileSync(path);

        var arr = new Array();

        for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

        success(arr.join(""));

    } else {

        // For browser

        var xhr = new XMLHttpRequest();

        xhr.open("GET", path, asy); // Async

        xhr.responseType = "arraybuffer";

        xhr.onload = function() {

            var data = new Uint8Array(xhr.response);

            var arr = new Array();

            for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

            success(arr.join(""));

        };

        xhr.send();

    };

};

OPTION 2: you can use Alasql library itself, which, probably, can be easier option.

alasql('SELECT * FROM XLSX("myfile.xlsx",{headers:true,sheetid:"Sheet2",range:"A1:D100"})',

     ,function(data) {

     console.log(res);

});

See the example here (simple Excel reading demo) or here (d3.js demo from Excel).

edited Dec 22 '14 at 15:12

answered Dec 22 '14 at 8:35

agershun

2,9371833

can you please provide complete code ?

– user1121210
Jun 12 '15 at 2:17

X and data are undefined in X.read(data,{type:'binary'})...

– Aprillion
Dec 24 '18 at 15:13

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f27523406%2fhow-to-read-excel-file-in-angularjs%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

-1

The following answer describe, if you are going to load xlsx file from server. For uploading there is another code.

OPTION 1: This is a procedure, which works in Alasql library:

See files: 15utility.js and 84from.js for example

readBinaryFile(filename,true,function(a){

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

    // do what you need with parsed xlsx

});



// Read Binary reading procedure

// path - path to the file

// asy - true - async / false - sync



var readBinaryFile = utils.loadBinaryFile = function(path, asy, success, error) {

    if(typeof exports == 'object') {

        // For Node.js

        var fs = require('fs');

        var data = fs.readFileSync(path);

        var arr = new Array();

        for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

        success(arr.join(""));

    } else {

        // For browser

        var xhr = new XMLHttpRequest();

        xhr.open("GET", path, asy); // Async

        xhr.responseType = "arraybuffer";

        xhr.onload = function() {

            var data = new Uint8Array(xhr.response);

            var arr = new Array();

            for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

            success(arr.join(""));

        };

        xhr.send();

    };

};

OPTION 2: you can use Alasql library itself, which, probably, can be easier option.

alasql('SELECT * FROM XLSX("myfile.xlsx",{headers:true,sheetid:"Sheet2",range:"A1:D100"})',

     ,function(data) {

     console.log(res);

});

See the example here (simple Excel reading demo) or here (d3.js demo from Excel).

edited Dec 22 '14 at 15:12

answered Dec 22 '14 at 8:35

agershun

2,9371833

can you please provide complete code ?

– user1121210
Jun 12 '15 at 2:17

X and data are undefined in X.read(data,{type:'binary'})...

– Aprillion
Dec 24 '18 at 15:13

add a comment |

-1

The following answer describe, if you are going to load xlsx file from server. For uploading there is another code.

OPTION 1: This is a procedure, which works in Alasql library:

See files: 15utility.js and 84from.js for example

readBinaryFile(filename,true,function(a){

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

    // do what you need with parsed xlsx

});



// Read Binary reading procedure

// path - path to the file

// asy - true - async / false - sync



var readBinaryFile = utils.loadBinaryFile = function(path, asy, success, error) {

    if(typeof exports == 'object') {

        // For Node.js

        var fs = require('fs');

        var data = fs.readFileSync(path);

        var arr = new Array();

        for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

        success(arr.join(""));

    } else {

        // For browser

        var xhr = new XMLHttpRequest();

        xhr.open("GET", path, asy); // Async

        xhr.responseType = "arraybuffer";

        xhr.onload = function() {

            var data = new Uint8Array(xhr.response);

            var arr = new Array();

            for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

            success(arr.join(""));

        };

        xhr.send();

    };

};

OPTION 2: you can use Alasql library itself, which, probably, can be easier option.

alasql('SELECT * FROM XLSX("myfile.xlsx",{headers:true,sheetid:"Sheet2",range:"A1:D100"})',

     ,function(data) {

     console.log(res);

});

See the example here (simple Excel reading demo) or here (d3.js demo from Excel).

edited Dec 22 '14 at 15:12

answered Dec 22 '14 at 8:35

agershun

2,9371833

can you please provide complete code ?

– user1121210
Jun 12 '15 at 2:17

X and data are undefined in X.read(data,{type:'binary'})...

– Aprillion
Dec 24 '18 at 15:13

add a comment |

-1

The following answer describe, if you are going to load xlsx file from server. For uploading there is another code.

OPTION 1: This is a procedure, which works in Alasql library:

See files: 15utility.js and 84from.js for example

readBinaryFile(filename,true,function(a){

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

    // do what you need with parsed xlsx

});



// Read Binary reading procedure

// path - path to the file

// asy - true - async / false - sync



var readBinaryFile = utils.loadBinaryFile = function(path, asy, success, error) {

    if(typeof exports == 'object') {

        // For Node.js

        var fs = require('fs');

        var data = fs.readFileSync(path);

        var arr = new Array();

        for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

        success(arr.join(""));

    } else {

        // For browser

        var xhr = new XMLHttpRequest();

        xhr.open("GET", path, asy); // Async

        xhr.responseType = "arraybuffer";

        xhr.onload = function() {

            var data = new Uint8Array(xhr.response);

            var arr = new Array();

            for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

            success(arr.join(""));

        };

        xhr.send();

    };

};

OPTION 2: you can use Alasql library itself, which, probably, can be easier option.

alasql('SELECT * FROM XLSX("myfile.xlsx",{headers:true,sheetid:"Sheet2",range:"A1:D100"})',

     ,function(data) {

     console.log(res);

});

See the example here (simple Excel reading demo) or here (d3.js demo from Excel).

edited Dec 22 '14 at 15:12

answered Dec 22 '14 at 8:35

agershun

2,9371833

The following answer describe, if you are going to load xlsx file from server. For uploading there is another code.

OPTION 1: This is a procedure, which works in Alasql library:

See files: 15utility.js and 84from.js for example

readBinaryFile(filename,true,function(a){

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

    // do what you need with parsed xlsx

});



// Read Binary reading procedure

// path - path to the file

// asy - true - async / false - sync



var readBinaryFile = utils.loadBinaryFile = function(path, asy, success, error) {

    if(typeof exports == 'object') {

        // For Node.js

        var fs = require('fs');

        var data = fs.readFileSync(path);

        var arr = new Array();

        for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

        success(arr.join(""));

    } else {

        // For browser

        var xhr = new XMLHttpRequest();

        xhr.open("GET", path, asy); // Async

        xhr.responseType = "arraybuffer";

        xhr.onload = function() {

            var data = new Uint8Array(xhr.response);

            var arr = new Array();

            for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);

            success(arr.join(""));

        };

        xhr.send();

    };

};

OPTION 2: you can use Alasql library itself, which, probably, can be easier option.

alasql('SELECT * FROM XLSX("myfile.xlsx",{headers:true,sheetid:"Sheet2",range:"A1:D100"})',

     ,function(data) {

     console.log(res);

});

See the example here (simple Excel reading demo) or here (d3.js demo from Excel).

edited Dec 22 '14 at 15:12

answered Dec 22 '14 at 8:35

agershun

2,9371833

edited Dec 22 '14 at 15:12

answered Dec 22 '14 at 8:35

agershun

2,9371833

answered Dec 22 '14 at 8:35

agershun

2,9371833

answered Dec 22 '14 at 8:35

agershun

2,9371833

can you please provide complete code ?

– user1121210
Jun 12 '15 at 2:17

X and data are undefined in X.read(data,{type:'binary'})...

– Aprillion
Dec 24 '18 at 15:13

add a comment |

can you please provide complete code ?

– user1121210
Jun 12 '15 at 2:17

X and data are undefined in X.read(data,{type:'binary'})...

– Aprillion
Dec 24 '18 at 15:13

can you please provide complete code ?

– user1121210
Jun 12 '15 at 2:17

X and data are undefined in X.read(data,{type:'binary'})...

– Aprillion
Dec 24 '18 at 15:13

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Tukukkk