SQL.js TableLoader
excel/csv file loader for SQL.js.
Usage
in Node.js
$ npm install sqljs-table-loaderimport fs from 'fs';
import initSqlJs from 'sql.js';
import TableLoader from 'sqljs-table-loader';
const data = fs.readFileSync(__dirname + '/file.xlsx');
const loader = new TableLoader(data, {/* options (see below) */});
initSqlJs(sql => {
const db = new sql.Database();
console.log(loader.sheets); // view sheet names included in excel file
console.log(loader.read({/* override options (see below) */})); // view table data
loader.importInto(db, 'target_table', {/* override options (see below) */}); // create table and import data
console.log(db.exec('SELECT * FROM target_table'));
});in browser
<script src="https://unpkg.com/xlsx"></script> <!-- required -->
<script src="https://unpkg.com/sql.js"></script> <!-- optional -->
<script src="https://unpkg.com/sqljs-table-loader"></script> <!-- this library -->
<script>
var loader = new TableLoader('foo,bar\n1,hello\n2,world');
console.log(loader.sheets);
console.log(loader.read());
</script>Options
| name | default | description |
|---|---|---|
| skip_row | 0 | Skip first rows |
| use_header | true | Use first row as column names |
| sheet | null | Sheet name to load (if null, load first) |
| delimiter | ',' | The delimiter for csv (only for constructor) |