Giter VIP home page Giter VIP logo

Comments (12)

SheetJSDev avatar SheetJSDev commented on May 4, 2024

There's always a solution :)

I suspect it may be a formatting issue (related repo: https://github.com/SheetJS/ssf) that hasn't been merged yet. Can you share the file? If you want to send it to me directly, [email protected]

from sheetjs.

 avatar commented on May 4, 2024

haha kewl :)

The file I was using is a sample from here: https://db.tt/2yXZkA7M

from sheetjs.

SheetJSDev avatar SheetJSDev commented on May 4, 2024

@Turg0n the node module works fine from here:

$ npm install -g xlsx
$ xlsx2csv ~/Downloads/Dubai\ Database.xlsx

https://gist.github.com/SheetJSDev/bd8775ead7503b4fb583/raw/939e5dc342475beebdd1bb82cebc60aad53a0e7b/Dubai+Database.csv

According to chrome, the issue is coming from the call

String.fromCharCode.apply(null, new Uint8Array(data));

When I change it to use the readAsBinaryString function and disable the worker, it appears to work:

        reader.onload = function(e) {
            var data = e.target.result;
            var wb = XLSX.read(data, {type: 'binary'});
            process_wb(wb);
            }
        };
        reader.readAsBinaryString(f);

It appears that IE9 supports readAsArrayBuffer but not readAsBinaryString https://developer.mozilla.org/en-US/docs/Web/API/FileReader.readAsBinaryString .

I will push a change so that it checks for rABS and only falls back to rAAB if the former is unavailable

from sheetjs.

 avatar commented on May 4, 2024

kewl. Ping me when you do so ^_^

Thank you for the bleeding fast response!! 👍

from sheetjs.

 avatar commented on May 4, 2024

any updates? :)

from sheetjs.

SheetJSDev avatar SheetJSDev commented on May 4, 2024

@Turg0n I pushed the aforementioned change to the gh-pages branch and it shows up at http://oss.sheetjs.com/js-xlsx/ Let me know if this works!

from sheetjs.

 avatar commented on May 4, 2024

I tried the interface and it works. Gona update my code and make sure it works there to :)

Cheers,
Piotr

from sheetjs.

SheetJSDev avatar SheetJSDev commented on May 4, 2024

@Turg0n is it working in your code? If so, close the issue :)

from sheetjs.

 avatar commented on May 4, 2024

yes yes, sorry man my bad :3
Thanks for being so responsive :) 👍

from sheetjs.

SheetJSDev avatar SheetJSDev commented on May 4, 2024

@Turg0n no worries, I appreciate your help in finding the issue :)

from sheetjs.

tjvg91 avatar tjvg91 commented on May 4, 2024

Hi guys.

I get the same error but i don't quite understand the solution. This is my code:

reader.onload = function(e) {
            var data = e.target.result;
            var wb = XLSX.read(data, {type: 'base64'});
        };
        reader.readAsArrayBuffer(f);

Please help. Thanks

from sheetjs.

tjvg91 avatar tjvg91 commented on May 4, 2024

Correction:

reader.onload = function(e) {
            var data = e.target.result;
            var arr = String.fromCharCode.apply(null, new Uint8array(res));
            var wb = XLSX.read(arr, {type: 'base64'});
        };
        reader.readAsArrayBuffer(f);

from sheetjs.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.