2017 © Pedro Peláez
 

library excelxsql

turn excel to db and query with sql

image

sinri/excelxsql

turn excel to db and query with sql

  • Friday, October 27, 2017
  • by sinri
  • Repository
  • 1 Watchers
  • 0 Stars
  • 1 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 1 Versions
  • 0 % Grown

The README.md

Excel×SQL

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., (*1)

How this works?

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

Usage

See example., (*3)

Note:, (*4)

  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.

You can donate through this alipay account., (*5)

http://www.everstray.com/resources/img/AlipayUkanokan258.png, (*6)

The Versions

27/10 2017

dev-master

9999999-dev

turn excel to db and query with sql

  Sources   Download

GPLv3

The Requires