alasql.min.js:10 Uncaught Error: Please include the xlsjs library

Created on 11 Oct 2016 · 18Comments · Source: agershun/alasql

Something wrong with the library. i try to upload a XLS files ( EXCEL 97 -2003 workbook) through http://alasql.org/demo/008file/.

It shows an error alasql.min.js:10 Uncaught Error: Please include the xlsjs library

i try to import the xlsx or xls files from cdnjs.com but it seems that it is not support.

importing CSV and XLSX are no problem but not XLS.

! Bug Code provided to reproduced Help wanted

Source

jefftham

Most helpful comment

@lzzattack I had the same problem.

I solved this:

import alasql from 'alasql';
import XLSX from 'xlsx';

alasql.utils.isBrowserify = false;
alasql.utils.global.XLSX = XLSX;

alexvingg on 22 Mar 2018

🎉9 👍1

All 18 comments

The demo is broken.

I will look into making a jsfiddle example...

mathiasrw on 12 Oct 2016

Btw: for excel support please use

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.7.12/xlsx.core.min.js"></script>

mathiasrw on 12 Oct 2016

🎉2

I did try that, but it doesn't work for xls format.

jefftham on 12 Oct 2016

It will solve

It shows an error alasql.min.js:10 Uncaught Error: Please include the xlsjs library

mathiasrw on 13 Oct 2016

i tested it before submitting this issue.

jefftham on 13 Oct 2016

XLS support have been added to the example. Please verify its working now...

mathiasrw on 16 Oct 2016

the problem is still existed.

jefftham on 27 Oct 2016

hmmmm

mathiasrw on 27 Oct 2016

Same issue is occuring to me

sherifalfy on 28 Sep 2017

@mathiasrw The versions need to be updated in the browser demos. Here's an updated plnkr of the 008file demo: http://plnkr.co/edit/Atqtg7RKrKbXtJ8eH6Qz?p=info

<script src="https://unpkg.com/[email protected]/dist/alasql.min.js"></script>
<script src="https://unpkg.com/[email protected]/dist/xlsx.core.min.js"></script>

SheetJSDev on 3 Oct 2017

🎉1

Awesome! I have updated https://github.com/agershun/alasql-org/blob/gh-pages/demo/008file/index.html so the change should be reflected on http://alasql.org/demo/008file/ any time soon

mathiasrw on 3 Oct 2017

this is my code:
alasql('SELECT * INTO XLSX("test.xlsx",{headers:true}) FROM ?', [vm.areaData])
but......
2017-10-21 6 20 29

this is my version:
2017-10-21 6 22 44
This is my way of using it
2017-10-23 10 24 55
oh！！I user vue-cli create project.

lzzattack on 21 Oct 2017

👍1

@lzzattack I had the same problem.

I solved this:

import alasql from 'alasql';
import XLSX from 'xlsx';

alasql.utils.isBrowserify = false;
alasql.utils.global.XLSX = XLSX;

alexvingg on 22 Mar 2018

🎉9 👍1

hi @alexvingg

After using

alasql.utils.isBrowserify = false;
alasql.utils.global.XLSX = XLSX;

I got error: error TS2339: Property 'utils' does not exist on type 'AlaSQL' in my angular application

could you please elaborate about utils in alasql as I did not manage to find any info about them

fuserMRX on 8 Apr 2018

hi @fuser84

This error happens because alasql does not find the XLSX dependency. My solution was to import the XLSX dependency and manually inject it into alasql. For it to work it is required isBrowserify = false.

I only tested with vue js.

alexvingg on 10 Apr 2018

Sorry for being late to the party.. All the angular guys, use this:-

import * as alasql from 'alasql';
import * as XLSX from 'xlsx';
alasql['utils'].isBrowserify = false;
alasql['utils'].global.XLSX = XLSX;

No need to include anything in your index.html or angular.cli.json.
Enjoy!

valentinoPereira on 26 Oct 2018

🎉2 ❤1

@lzzattack I had the same problem.

I solved this:

import alasql from 'alasql';
import XLSX from 'xlsx';

alasql.utils.isBrowserify = false;
alasql.utils.global.XLSX = XLSX;

Well done with these configs in Vue. Thanks a lot.