Node.js script to read an Excel spreadsheet into a PostgreSQL database.
$ npm install -g excel-sql
$ excel-sql MySpreadsheet.xlsx Creating database MySpreadsheet Creating table Sheet1 Inserting 171 rows Creating table Sheet2 Inserting 0 rows
Uses the fabulous
xlsx library for parsing the Excel spreadsheet.
It does some simple regular expression-based type inference, automatically distinguishing between
REAL, as well as some formats of
- Support more types in the type inference part
- Infer foreign relationships if possible
Copyright 2016 Christopher Brown. MIT Licensed