sinri/excelxsql

turn excel to db and query with sql

dev-master 2017-10-27 07:19 UTC

Requires

• box/spout: ^2.7

GPLv3

• Sinri Edogawa

README

This project is design to make possible that use Excel Sheets as database tables and run SQL query on them. For those are familiar with database and SQL but not expert for Excel, it might help.

How this works?

Simple, read the excel and set up a database of SQLite3, then you can run query SQL, export result and more.

Usage

See example.

Note:

1. Prepare the source .xlsx files. Excel sheet cells are sometimes expressing strangely, especially on numeric values.
2. Prepare the sqlite3 database file. As default memory embedded database instance might be a waste of memory, you may determine a file.
3. Use a proper load method to load. For almost situations, loadSheetWithTypeDefinition works best.
4. You may need to output as xlsx file. Note currently only one sheet might be generated.

Donate

You can donate through this alipay account.