Read-only JDBC driver for Microsoft Excel .xlsx files
The conceptual mapping between spreadsheet and JDBC is:
The sample file chinook.xlsx contains a spreadsheet of the type readable by this driver.
jdbc:JDBCExcel://server={SERVER};database={DATABASE}
where
{SERVER} = path name to folder containing one or more Excel .xlsx files
{DATABASE} = name of an Excel .xlsx file
This driver accepts simple single-table queries of the following form:
select a,b,*,'literal',[quoted name 1],"quoted name 2" as quote2
from tableName
limit 500
Calculations, where clauses, joins and other query elements are not currently supported.