Comments (12)
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.
haha kewl :)
The file I was using is a sample from here: https://db.tt/2yXZkA7M
from sheetjs.
@Turg0n the node module works fine from here:
$ npm install -g xlsx
$ xlsx2csv ~/Downloads/Dubai\ Database.xlsx
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.
kewl. Ping me when you do so ^_^
Thank you for the bleeding fast response!! 👍
from sheetjs.
any updates? :)
from sheetjs.
@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.
I tried the interface and it works. Gona update my code and make sure it works there to :)
Cheers,
Piotr
from sheetjs.
@Turg0n is it working in your code? If so, close the issue :)
from sheetjs.
yes yes, sorry man my bad :3
Thanks for being so responsive :) 👍
from sheetjs.
@Turg0n no worries, I appreciate your help in finding the issue :)
from sheetjs.
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.
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)
- Gettting an Array, but of scrambled data 😰 HOT 2
- sheet_to_json from remote file not working HOT 2
- Unable to set name for worksheet separately from workbook HOT 3
- xlsx CP932 Incorrect output HOT 3
- Error appears in bower js-xlsx#~0.11.5 HOT 4
- sheet_to_json: inconsistent blank cell parsing HOT 2
- format entire column HOT 2
- reading text in shapes HOT 1
- Rearranging the XLSX.write order HOT 1
- Add VBA script to file I am creating from scratch HOT 2
- Wrong filename when download file HOT 1
- How to Define name for a range ? HOT 1
- Need to Prevent formatting of dates while reading a csv
- No option to change delimiter when writing CSV HOT 1
- Export to excel- Hyperlink doesn't work on documentation page HOT 1
- reading and writing the excel with Symbols,photos, in different tabs.
- QUOTE not defined HOT 9
- [Security] Prototype Pollution in sheetJS HOT 27
- Archive this GitHub Project HOT 3
- Thanks!
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sheetjs.