search

AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
http://alasql.org
MIT License
6.96k stars 651 forks source link

Investigate ExcelJS (Excel manipulation library) and Jacob (lexer/parser) libraries #81

Open agershun opened 9 years ago

agershun commented 9 years ago

ExcelJS

https://github.com/guyonroche/exceljs

Reasons:

https://github.com/Canna71/Jacob http://dailyjs.com/2015/03/05/jacob/

Reasons:

mathiasrw commented 9 years ago

You could also look into if you could use

https://github.com/thinkpad20/sql

and compile the C code via emscripten to asm.js for this part of the library - check out

http://ejohn.org/blog/asmjs-javascript-compile-target/

pietersv commented 9 years ago

xlsx has a branch that allows exporting fill and font colors. Passing thought re size of parser, is it possible to make xlsx external to alasql and imported via a separate <script> or require() call? That way its loaded only when Excel parsing is required. Perhaps either a parameter that's passed to alasql on initialization or something that alasql can recognize if it already exists in the local or global scope.

agershun commented 9 years ago

xlsx has a branch that allows exporting fill and font colors.

I could not find this branch. Could you provide url? It is a really good news.

pietersv commented 9 years ago

The current branch is https://github.com/protobi/js-xlsx. Formats are specified by the .s attributes in a cell, as in {v: 1.618, s: { numFmt: "0.00", fill: { bgColor: { rgb: "#FFFFAA00"}}}} Aim to present this a pull request as I complete unit testing, and am monitoring this discussion for issues https://github.com/SheetJS/js-xlsx/issues/128