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
1
vote
0 answers

alasql how to download excel in .xlsx format with styles

What am I doing I am generating excel on client side using alasql library. I get JSON data from API and then I pass that data to alasql library to get excel downloaded with styles. What is working Downloaded file gets saved in .xls extension with…
Alvin
  • 290
  • 5
  • 25
1
vote
1 answer

Unable to perform date filter after exporting JSON date to excel using javascript function

I'm using below function to export JSON with dates(DD/MM/YYYY) into excel using alasql function exportToExcel() { var loginInfo=[ { "Login Date": "5/3/2018" }, { "Login Date": "15/4/2018" }, { …
forgottofly
  • 2,729
  • 11
  • 51
  • 93
1
vote
1 answer

AlaSql error while exporting XLS from HTML with style formatting

Alasql seems very helpful to export XLS files from JS and easy too. But there is a lack of good tutorial or maybe I didn't find one. During export XLS directly from HTML it works fine but I am not able to add some cell formatting in this process. I…
Avisek Chakraborty
  • 8,229
  • 10
  • 48
  • 76
1
vote
1 answer

alasql- Undefined error

I am pulling data using sharepoint rest service and querying the result data using alasql library. When selecting the field it is returning the data. However, if i use it in group by/sum statement, getting undefined values. For example: Query for…
ravi
  • 69
  • 4
1
vote
0 answers

how i get data with accent when i do a select in alasql

I´m trying to get data inside a csv file using alasql http://alasql.org , but when i put a file (.csv) in a input file, and i do a select with alasql and some word contain accent i get this simbol "�" where contain accent in that word, i search and…
Fernando josé
  • 249
  • 4
  • 10
1
vote
0 answers

AlaSql Excel (.xls) formatting cell value to be of number

I am using AlaSql 0.4.2 to export to excel. Details about the issue is mentioned at : https://github.com/agershun/alasql/issues/967 I would like to know how to set the option while exporting such that the cell format should be number instead of…
user1643830
  • 21
  • 3
1
vote
0 answers

How to write on XLSX file using Javascript Array

I need suggestion on how to make a XLSX file using (Javascript array or JSON) and Style Object. I am already using alasql for generating the XLS file. But on opening of that file some advisory message is coming (verify that the file is not…
Niraj Sazzie
  • 61
  • 8
1
vote
0 answers

AlaSql Rows and Columns formatting when exporting to excel (.xls)

I am using AlaSql version 0.4.2. I am exporting to excel through following way : var mystyle = { headers: true, sheetid: 'Counter Correction', }; //Create XLS format using alasql.js file. var…
user1643830
  • 21
  • 3
1
vote
3 answers

How to SQL SELECT from JSON and dynamically assign to variables

TL;DR - I would like to SQL from the format of "test.json" (example below) and I would like to assign each of the variables dynamically so that depending on how many entries there are it will output that amount (So it would look like the output…
qtt qtt
  • 187
  • 3
  • 5
  • 19
1
vote
1 answer

alasql doesn't write all table values to excel file using angularjs

I am able to write the table values to excel file from here (https://github.com/agershun/alasql/wiki/How-to-export-HTML-table-to-Excel) But when i add bottom header it doesn't import. Please find the updated example here from github link and added…
Shan
  • 295
  • 1
  • 5
  • 16
1
vote
0 answers

how to set column data type for export xls using alasql?

I want to set the column type when exporting an xls using alasql. I was looking for but I do not understand the documentation. If someone has an example, it would be very helpful. I'm programming in angularjs
Diego Valsagna
  • 11
  • 1
1
vote
1 answer

How to have persistant database using alasql

I've try this on Codepen: var result = db.exec('CREATE DATABASE IF NOT EXISTS MyBase; \ ATTACH INDEXEDDB DATABASE MyBase;\ USE MyBase;'+command)[3]; but after first command I've got exception that…
jcubic
  • 61,973
  • 54
  • 229
  • 402
1
vote
0 answers

Using Alasql in AngularJS Factory

So I am making an AngularJS project and want to put my alasql functionality within a factory that I will inject into my controllers. However, I am getting a console error stating that alasql is not defined in my factory. Here is my code for some…
mrdcs92
  • 49
  • 1
  • 1
  • 4
1
vote
1 answer

Update Alasql database details based on existing data

I have an Alasql Database that looks like this: results Name Recieved Bill 10/11/17 7:42 AM Susan 10/05/17 3:43 AM Sarah 10/04/17 2:08 PM I'm trying to update it to convert the Recieved table and convert it into a unix…
Jordash
  • 2,926
  • 8
  • 38
  • 77
1
vote
0 answers

alasql: application performance is not affected when saving all data in an object?

I'm developing an electronjs application I have a table that has 35 fields and users will record an approximate between 5000 and 40000 records in that table per month. I did some storage tests with FILESTORAGE of alasql and saved the objects of the…
Alan Olivares
  • 336
  • 2
  • 13
1 2 3
…
14 15