A Clojure Leiningen application to import table data from Excel files to database tables.
clj-xlsx2db has two commands. Both commands reads file paths and database connection informations from ini file. It works only with PostgreSQL database for now.
Use "export-table-info" to export template Excel files to write in your data.
lein run export-table-info <ini-file-path>
Use "export-table" to export Excel files with data.
lein run export-table <ini-file-path>
Use "import-table" to import your data from Excel.
lein run import-table <ini-file-path>
- xlsx/import-path
- Excel file path to import from.
- xlsx/export-path
- Excel file path to export info to.
- db/dburl
- Database host, port and name
- db/dbuser
- Database user
- db/dbpass
- Database password
- db/dbprotocol
- Database protocol. "postgresql" only for now.
- db/tables
- Comma separated table names. clj-xlsx2db exports/imports tables specified here.
Here's a sample ini file: clj-xlsx2db/resources/sample.ini
Copyright © 2016 Hiroki Tanaka
Distributed under the Eclipse Public License either version 1.0 or any later version.