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

AlaSQL set result to variable for use elsewhere

I'm fairly new to JavaScript and AlaSQL, so sorry if this is obvious. I'm trying to save the result of my AlaSQL query to a variable so I can use it elsewhere in my code. As a bit of context, I'm querying a CSV file, and I'm wanting to get the max,…
Tim R
  • 3
  • 1
  • 4
0
votes
1 answer

Alasql - How to get the sheet names from an xlsx file?

According to: https://github.com/agershun/alasql/wiki/XLSX you can send in the sheetid to read out a different sheet. I can't however find any way to read out the available sheets. Does anyone know how this should be done?
Samantha Adrichem
  • 833
  • 1
  • 12
  • 23
0
votes
2 answers

Angular JS + AlaSQL import

I am working on a project where I had to import Excel data and create a web view for it, my current solution now is to parse it on C# and send the JSON result as API, I just discovered AlaSQL, importing the data with pure JS worked fine, but I can't…
Anouar Ghali
  • 53
  • 7
0
votes
1 answer

Read data in formatted tables in excel javascript

I need to read data from an excel file. In the excel file, there are formatted tables which contains the data I need to retrieve. Is there an API available to do this? Currently, I'm using to read data in Excel is the ALASQL wherein it returns a…
FEDeveloper
  • 33
  • 1
  • 7
0
votes
0 answers

Add extra cell in excel using alasql

How I can add a cell above the headboard ? Thank you, great job Example Image My intention is to put multiple cells above the table using materials alasql
Shubham Pramanick
  • 13
  • 2
  • 5
0
votes
0 answers

How to display border using alasql

How to add border using alasql in Excel. I was trying add border object report style. Var reportstyle={row:{style:{borders:{left:'1px solid black '}}}} It's not adding the left border. Can you please help on this
Vsquare
  • 24
  • 3
0
votes
1 answer

Is AlaSql Support GROUPING function?

*Sorry,I made some mistakes,and crude manners. Now I trying to make Sales Summary Report with AlaSql, heres my code: var testData = [ { Area: "Area 1", Shop: "Shop 1", Val: 5 }, { Area: "Area 1", Shop: "Shop 2", Val: 20 }, {…
Daisuke E
  • 1
  • 1
0
votes
2 answers

JavaScript check excel document for matching numbers

I have a simple input form where you type 6 numbers, when you click the button the JavaScript will check a excel document if the numbers you entered matches a row. if so you win if not you loose. I cant workout how to check the spread sheet to query…
Beep
  • 2,737
  • 7
  • 36
  • 85
0
votes
1 answer

Is it possible to add Excel sheets using alasql in angularJs

I want to export data of two different arrays in a single excel document. The data of two different arrays should be exported in two different sheets. $scope.details= { "boys": [ {"name":"Jeet", "age":25}, …
JEET ADHIKARI
  • 529
  • 2
  • 6
  • 19
0
votes
0 answers

Javascript: Open excel file on browser side

I'm new here. If I'm doing something wrong just tell me. Thanks ;) My Problem: I need to open an excel file from the client. The user has to choose a file in a form in HTML or JS and then JS needs to open this file and parse it. This fiddle is a…
StevoG26
  • 1
  • 2
0
votes
1 answer

Exporting Multiple HTML tables to excel such that each HTML table is in a new column

I'm trying to use alasql to export a set of HTML tables into an excel document. The documentation has code that looks similar to this: var data1 = alasql('SELECT * FROM HTML("#dev-table",{headers:false})'); var data2 = alasql('SELECT * FROM…
Allen Roush
  • 3
  • 4
0
votes
0 answers

Change sorting in autocomplete from ASCII alphabetical ordering in select2 to Unicode

I am faceing for the first time against select2 library. I have coded a search box and is working fine except for the sorting. For now is ordering the results by an ASCII order instead Unicode. For example: "Lu" comes before "Lé". However I need…
Breo
  • 1
  • 3
0
votes
1 answer

Excel page property using AngularJS

I am generating an Excel file using AngularJS. The page styling format is working fine, but I need help to set the page property of print area and orientation landscape. Code: var mystyle = { sheetid: 'Sheet1', headers: false, …
Shaan
  • 1
  • 3
0
votes
2 answers

alasql sheetname with special characters

How can I export an excel files with multiple sheets with special characters in sheet name? For example, I tried this but the file cannot be opened: window.saveFile = function saveFile () { var data1 = [{a:1,b:10},{a:2,b:20}]; var data2…
Jerry
  • 97
  • 5
0
votes
1 answer

Excel Table to Html table

I have been trying to get an Excel file into my code and then generate a table with it. I don't know what is wrong with my code. It doesn't show any errors, but it doesn't work either.... Please Help, I think the file loaded might not be getting…
Miguel Kulisic
  • 129
  • 2
  • 10
1 2 3
…
14 15