Latest feature:

• v4.1.008 provides five regular expression functions(REGEXP_COUNT, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, and REGEXP_SUBSTR)
• v4.1.005 optimizes speed for DISTINCTROW on multi tables.
• v4.1.001 supports JDBC 4.1.

2011-10-11 Excel v4.1 JDBC1.2 Package(1199KB) JDBC2.0 Package(1178KB) JDBC3.0 Package(1213KB) JDBC4.0 Package(1323KB) JDBC4.1 Package(1327KB)

• v4.0.004 replaces LONGVARCHAR type with VARCHAR type, for date type detect.
• v4.0.004 roundes double value according to cell format.
• v4.0.003 provides caseInsensitive connection property.

2011-06-02 Excel v4.0 JDBC1.2 Package(1091KB) JDBC2.0 Package(1118KB) JDBC3.0 Package(1150KB) JDBC4.0 Package(1255KB)

• v4.0.001 supports CREATE/DROP DATABASE, CREATE/DROP/ALTER TABLE, INSERT, UPDATE, and DELETE, for XLSX format (MS Excel 2006/2010).
• v3.0.020 supports PIVOT expression besides column.
• v3.0.019 supports [START WITH initial-condition] CONNECT BY [NOCYCLE] recurse-condition. level is a pseudo column that can be used in hierarchical queries.
• v3.0.016 provides read-only support for XLSX format (MS Excel 2006/2010).
• v3.0.014 adjusts Daylight Saving Time for timestamp show.
• v3.0.002 supports CREATE VIEW and DROP VIEW.

2011-04-05 Excel v3.0 JDBC1.2 Package(912KB) JDBC2.0 Package(945KB) JDBC3.0 Package(980KB) JDBC4.0 Package(1075KB)

• SELECT ... FOR UPDATE will lock all the selected rows for transaction until transaction commit or rollback even if you close that ResultSet since v2.2.200.
• SELECT ... FOR UPDATE will lock all the selected rows so that other users cannot lock or update the rows until you close that ResultSet since v2.2.198.
• v2.2.174 supports function decode( expression , search , result [, search , result]... [, default] )
• v2.2.156 fixed a fetch reverse bug from the bottom of an Excel's ResultSet.
• v2.2.137 provides tmpdir=_memory_ connection property.
• v2.2.108 allow firstRowHasNames connection property to use the data row start from the firstRowHasNames+1 row.
• v2.2.107 supports CREATE DATABASE from any input stream.
• v2.2.084 fix a bug for DOUBLE/DATE data detection since v2.2.043.
• v2.2.080 supports '[]' to specify a range of characters for LIKE/ILIKE.
• v2.2.070 supports full ALTER TABLE sql.
• v2.2.038 fixed a bug on LEFT JOIN, which will return empty result for specific condition.
• v2.2.036 can read invalid xls file, which is produced by Java Excel API with invalid author information.
• v2.2.015 fixed a bug on writing specific xls file since v2.1.015.
• v2.2.005 supports DISTINCT parameter for the aggregate functions of COUNT, SUM, and AVG.
• v2.2.001 supports JDBC4.0.

2008-09-22 Excel v2.2 JDBC1.2 Package(948KB) JDBC2.0 Package(934KB) JDBC3.0 Package(972KB) JDBC4.0 Package(1065KB)

• v2.1.016 fixed a bug which the first row become invisible in MS Excel when that row is frozen.
• v2.1.011 fixed a bug on ResultSet.last() since v2.0.046.
• v2.1.004 supports WITH ROLLUP, WITH CUBE, and GROUPING(expression).
• v2.1.004 supports bitwise logical operator(&, |, ~, ^, <<, >>), BITAND(x, y), and BIT_COUNT(x).

2008-07-23 Excel v2.1 JDBC1.2 Package(944KB) JDBC2.0 Package(932KB) JDBC3.0 Package(969KB)

• v2.0.036 supports GROUP_CONCAT function.
• v2.0.035 supports to assign more than one extension for otherExtension connection property.
• v2.0.034 supports lower(upper) function in LIKE expression.
• v2.0.001 supports INTO variable[,...] for SELECT sql.
• v2.0.001 supports SET variable = expression [,...].
• v2.0.001 supports DECLARE Local Variables.

2007-10-29 Excel v2.0 JDBC1.2 Package(953KB) JDBC2.0 Package(940KB) JDBC3.0 Package(979KB)

• v1.1.084 replaced "? Expression" with "SELECT select_list".
• v1.1.080 provides SHA1 function besides MD5 and Crypt3.
• v1.1.078 can detect data type according to format information for cell, row, column, sheet, and workbook, when there's no data.
• v1.1.071 can detect data type from "column format" in excel when it meets empty column.
• v1.1.070 can detect data type from "cell display format" in excel when it meets empty cell.
• v1.1.069 fixed a bug in detecting date value with customer defined format.
• v1.1.068 changed the visibility of columns in JOIN table with parentheses from invisible to visible.
• v1.1.068 supports JOIN and subquery in PIVOT and UNPIVOT.
• v1.1.066 fixed an update bug when meets mixed blank cell and numeric cell.
• v1.1.057 supports seamlessly https url database in jdbc url and sql.
• v1.1.010 provides maxScanRows connection property for auto data type detection, but it still supports using different data types for a column.
• v1.1.001 supports SAMBA table, which needn't to map or mount driver.

2007-01-11 Excel v1.1 JDBC1.2 Package(931KB) JDBC2.0 Package(918KB) JDBC3.0 Package(955KB)

• v1.0.047 optimizes memory occupation for UNION ALL.
• v1.0.044 added CP850, CP852, CP866, CROATIAN, HEBREW, and SWEDISH sort for COLLATE function.
• v1.0.042 fixed an output bug for compressing multiple number values on a row.
• v1.0.025 provides function getNumber, getInt, getLong, and getDouble.

2006-08-15 Excel v1.0 JDBC1.2 Package(918KB) JDBC2.0 Package(905KB) JDBC3.0 Package(942KB)

• supports seamlessly url(http, ftp) database in jdbc url and sql.
• supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
• supports seamlessly files and directories in ZIP, GZIP, TAR and BZ2 file formats(.ZIP, .JAR, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
• supports all of four transaction levels.
• supports CREATE DATABASE, CREATE CATALOG, CREATE TABLE, DROP TABLE, RENAME TABLE, SELECT, INSERT, UPDATE, and DELETE sql.
• Development Documentation is available.
• supports JDBC3.0, JDBC2.0 and JDBC1.2.
• supports create/query/update Microsoft Excel file version from 95, 97, 98, 2000, 2001, 2002, 2003, to 2004.