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
1 answer

How To: Display Data from AlaSQL Excel File Import within HTML/ASP Page

I am in the process of working on an internal website that will need to pull data exclusively from static XLSX spreadsheets (updated through automation daily). On this site, I the data will need to be posted in a table and sortable/searchable. I can…
James
  • 21
  • 4
0
votes
1 answer

Is there a way to create an XLSX with multiple sheets using alaSql?

What i´m trying to do is generating an xlsx file with multiple sheets by using alaSql . They only need to have the columns and no data at all (it´s going to be used as a template available for download) var tasksData = [{ UserName:"", …
Tigre1902
  • 31
  • 8
0
votes
1 answer

How to read a specified sheet from .xlsx file by it's sheet name in alasql

I, want read a excel file(xls or xlsx), used alasql to read the file. But I want get a specified sheet(by name). how it will do. Any good leads is appreciable.. I done some work, alasql('SELECT * FROM…
ngle
  • 79
  • 1
  • 9
0
votes
1 answer

map key value pairs while export excel sheet using alasql

I am working on export into excel sheet requirement using 'alasql'. My Javasript object to be given as input to alasql is 0: ContactEmail: "email1@example.com" ContactName: "abcd" CustomerName: "defg" SubdomainName: "adasdasd" 1: …
Prasad Patel
  • 707
  • 3
  • 16
  • 53
0
votes
0 answers

SQL Query For Multiple Indirect Relationships

I have a question about whether I can extract indirect relationship information from a SQL database, just using SQL. A modelling tool I'm using is based upon an SQL database that essentially has just two tables: Elements and Relations. The table…
P Burke
  • 1,630
  • 2
  • 17
  • 31
0
votes
0 answers

Uncaught table not found alasql

I used alasql and defined created table in node js, like this : **app.listen(5556,'0.0.0.0', () => { alasql("CREATE TABLE IF NOT EXISTS cart (ID INT AUTOINCREMENT, IDITEM INT,KODEBARANG STRING, NAMA STRING, QTY INT, PRICE INT, SUBTOTAL INT)"); …
Agoeng Liu
  • 674
  • 3
  • 10
  • 30
0
votes
2 answers

alasql returning incorrect value for Date field

I am using the below code to read the excel data using ALASQL alasql('SELECT * FROM FILE(?,{headers:true})', [event], function (data) { excelData = data; }); This works for all the fields except the date field The date field has…
Vignesh Subramanian
  • 7,161
  • 14
  • 87
  • 150
0
votes
1 answer

AlaSQL JSON to XLSX not working

I am trying to convert JSON data into CSV and XLSX and have 2 buttons that will allow me to download the CSV and XLSX form. The CSV button works but the XLSX one does not. I have tried many things such as: var filename =…
javacash
  • 163
  • 3
  • 13
0
votes
1 answer

Proper place to retrieve and calculate additional totals from filtered data

Right now I am using the renderlet function of one of my charts on the page to calculate summary totals of the filtered data. in this PEN Year Over Year Charts saleschart.renderlet(function (chart) { // rotate x-axis labels …
Richard Davison
  • 141
  • 1
  • 7
0
votes
0 answers

Alasql - Create Excel with Wraptext and Multiple Sheets

I need to create an Excel file with multiple sheets and wraptext. When I use XLSX, I am able to create the multiple sheets. But wraptext is not working with xlsx. I have been able to do wraptext with XLS, but this time multiple sheets are not…
S..
  • 101
  • 6
0
votes
1 answer

alasql - column names when using with csv?

I'm trying to see how to reference column names when using alasql from the command line, when there's no header in the file? I've tried a few different options with no luck. e.g $ alasql 'SELECT a[1] FROM TAB(?) as a' data.csv $ alasql 'SELECT [1]…
Brad Parks
  • 66,836
  • 64
  • 257
  • 336
0
votes
0 answers

Alasql Query not Working

I have this alasql query I need to count a total, then if the row has a bool that is true, to count those ones. However, for whatever reason it just counts all the rows including the ones that are false. var groupedShipDatesAndCabinetCounts =…
DalTron
  • 939
  • 3
  • 9
  • 22
0
votes
1 answer

Join two select statements containing a where clause using alasql in node.js

I am using alasql in node.js, and I cannot get a join to work. Here you have dummy data: x = [ { date: 20180501, price: 23, product: 'x' }, { date: 20180501, price: 46, product: 'y' }, { date: 20180502, price: 29, product: 'x' }, { date: 20180502,…
Daniel Ortega
  • 75
  • 5
0
votes
0 answers

Alasql is not working in angularjs controller

I am referring for this link to work with alasql in angularjs http://plnkr.co/edit/2UKA8yPl9Uiarr2uSwEd?p=preview. But even though i change the alasql sources it still throws Reference error:alasql is not defined in the controller.What else should i…
GrailsLearner
  • 485
  • 1
  • 11
  • 23
0
votes
1 answer

Sort an object literal on its attribute value

Below is my input, I would be looping through each of this element and sending each element to another function. distinctParameterList = [{ careerGroupLevel: 'Analyst', careerGroupCode: 130, m06: 83, m05: 82, …
rp4361
  • 433
  • 1
  • 5
  • 20
1 2 3
…
14 15