search

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
http://alasql.org
MIT License
7.01k stars 651 forks source link

Exporting data From Excel to json not working using alaSql #880

Open Rajani-Igit opened 7 years ago

Rajani-Igit commented 7 years ago

Hi I am trying to get data from Excel to json object using alasql
The code is as fallows loadFile = function(event) { alert("select from excel"); alasql('SELECT * FROM XLSX(?,{headers:true})',[event],function(data){ alert("hkjhgskh"); print(data) }); The controll is going to that function after choosing the file but it showing the fallowing error.

xlsx.core.min.js:13 Uncaught TypeError: f.charCodeAt is not a function at firstbyte (xlsx.core.min.js:13) at Object.readSync [as read] (xlsx.core.min.js:13) at alasql.min.js:2 at FileReader.i.onload (alasql.min.js:10)

Plese help me . 

​

mathiasrw commented 7 years ago

What version of alasql are you using?