Stack Overflow
Stack Overflow

Questions tagged [alasql]

Alasql - is a SQL database and data manipulation library, written in pure JavaScript and designed to work in browsers and Node.js. It provides a SQL language interface and data processing functions to data arrays. The library also provides import/export functions for CSV, TAB, JSON and other data file formats. It can use LocalStorage and IndexedDB as backend storage.

Alasql - 'à la SQL' - is a lightweight JavaScript SQL database designed to work in browser, Node.js, and Apache Cordova. It supports traditional SQL with some NoSQL functionality. Current version of Alasql can work in memory and use file, IndexedDB, and localStorage as a persistent storage.

See also

Useful links

225 questions
0
votes
0 answers

test.html:208 Uncaught ReferenceError: createtable is not defined

Ive been trying to make a webpage that can read an excel file and then create a table out of it. I already got the table generating part to work, but I can't get the loading part to work. I am getting an error that says that my function is not…
Miguel Kulisic
  • 129
  • 2
  • 10
0
votes
1 answer

alasql plugin not able to download the file in safari browser

I am using alasql plugin to generate and export excel file in javascript. This works fine, but in safari browser in ipad/iphone it does not download any excel and sometimes gives error like cannot download the file. How do i solve this issue in…
Hacker
  • 7,798
  • 19
  • 84
  • 154
0
votes
1 answer

Pivot on multiple columns in alasql

I am new to Alasql, I wonder how can I create a PIVOT and show two aggregation. In below example how can I show AVG of values and SUM of price for each name and security. Also how can I give alias name for each aggregation i.e. …
Mayur
  • 1,123
  • 3
  • 22
  • 38
0
votes
1 answer

AlaSQL can you use DISTINCT with SEARCH

Say I have an array that looks like this: var data = [{ "categories": [{ "categoryName": "‌belt‌", "categoryValue": "‌white‌" }, {"categoryName": "‌level‌", "categoryValue": "‌Beginner‌"}, { "categoryName": "‌type‌", …
Amy Blankenship
  • 6,485
  • 2
  • 22
  • 45
0
votes
0 answers

How to protect Excel document from editing in AlaSQL

I am using AlaSQL library to export JSON into an Excel workbook. I want the workbook to be read-only -- so that no-one can edit the contents of the cells, they can only read it. Is that possible in AlaSQL?
Sanjeev
  • 41
  • 3
0
votes
2 answers

using npm to install a development version

There is a minor issue with alasql, and the developer has kindly suggested using v0.3.6-develop-1476 instead of just v0.3.6 for now, and the issue will be corrected very soon. I know very little about npm except how to install, remove, and list. …
edwardsmarkf
  • 1,387
  • 2
  • 16
  • 31
0
votes
2 answers

Compress .xls/xlsx files into .zip files jsZip

I'm a newbie to the field of javascript/angularJS, so please bear with me.I need a way to convert .xls/.xlsx files into .zip files by using jsZip library. I'm making use of alasql for generating the .xls file. I've looked all over for any possible…
code.rhyme
  • 67
  • 4
  • 12
0
votes
2 answers

How to download excel using Angular JS

My Java REST service(POST call) is providing an excel file as response using hssfWorkbook and returning excel in xls format. response.getOutputStream(); hssfWorkbook.write(out); I have tried Filesaver but it will work for JSON as reponse. I didn't…
user3428736
  • 864
  • 2
  • 13
  • 33
0
votes
1 answer

AlaSQL inserting into table from CSV doesn't work

Trying to copy CSV data to internal table of AlaSQL. But SELECT * INTO tab FROM CSV() - simply doesn't work. Nothing changed after this. Table tab still empty, but direct select works fine. What i'm doing wrong? …
a.oberon
  • 193
  • 1
  • 10
0
votes
1 answer

alasql- Record Update Issue

I'm Trying to update record on a specific condition. alasql("UPDATE MyDatabase.FooTBL SET Column2 = 1 Where Column1 = 'foo'") It Throws error on console Uncaught TypeError: Cannot read property 'tables' of undefined(…) Can anyone suggest the…
Abdul Jabbar
  • 348
  • 2
  • 10
0
votes
1 answer

how can i do to give background color to the headers using alasql?

what is the right key word to give the header a bgcolor ? window.exportExcel = function exportExcel(listPersone) { var fileName=prompt(); var opts = { headers:true, …
Mohammed el amine Rahiq
  • 21
  • 6
0
votes
0 answers

Interfacing an Sqlite database using a web interface

I'm relatively new to web design and i am looking for the best way to interface with an sqlite database using a web interface to adjust values that are stored in the database. the existing sqlite database will be stored locally on the device that…
EthanW05
  • 1
  • 1
0
votes
2 answers

How to remove trailing space from SQL or javascript object column names

Before anyone starts to lynch me saying that this question has been asked thousands of times, I'd like to point out that I need to remove trailing spaces from column names, not data entries, and I haven't found any way to do this. So, I'll explain…
Hankrecords
  • 344
  • 5
  • 18
0
votes
1 answer

Alasql import from upload button vs file onchange event

I am trying to figure out how to import a file into ALASQL from a file input. There is documentation on how to do this but my client wants to have to press a load button vs when choosing the file. Here is the documentation from ALASQL:
Nick Schild
  • 129
  • 10
0
votes
0 answers

Save xls in cordova from alasql

I have an android cordova application which is supposed to save and send xls file (via email) generated from an array. So far I have created the xls file using alasql code: var data = [{a:23,b:10},{a:2,b:20}]; alasql('SELECT * INTO…
Epizefiri
  • 1
  • 3
1 2 3
…
14
15