HXTT Excel: A Pure Java JDBC Driver for Excel XLS and XLSX Workbooks
HXTT Excel is a pure Java (type 4) JDBC driver with a built-in database engine that lets Java programs query and update Microsoft Excel workbooks with SQL, treating each worksheet as a table, without Excel, Office or ODBC installed. It's for Java developers and DBAs who have to read or write .xls and .xlsx files on servers, including Linux. A Single Server License costs $385, one-time.
Spreadsheets are where a lot of business data starts: price lists from suppliers, budgets from finance, survey results, monthly reports that someone has to load into a system. In Java that usually means a spreadsheet API and many lines of code walking rows and cells. With HXTT Excel you write SELECT region, SUM(amount) FROM "sales.xlsx".sheet1 GROUP BY region instead, and report tools that speak JDBC can use the workbook directly.
Quick facts
- Version: 6.1.279, built July 13, 2026
- Developer: Heng Xing Tian Tai Lab of Xi'an City (HXTT), which also makes JDBC drivers for Access, DBF, Paradox and CSV files
- Platform: any operating system with a Java VM; JDBC 1.2, 2.0, 3.0, 4.0, 4.1, 4.2 and 4.3 packages
- Formats: Excel 95 to 2016 workbooks: XLS (BIFF7 and BIFF8), XLSX and Strict Open XML
- Price: $385 Single Server, $1,767 100 User Application, $2,681 Enterprise; perpetual, with one year of free upgrades and email support
- Trial: free 30-day evaluation package; it runs at most 50 queries per session and returns only the first 100 rows of a SELECT
- Refunds: requested through 2Checkout within 30 days of the order
- What we checked: the evaluation download excel.zip (1.9 MB), whose Excel_JDBC30.jar reports version 6.1.279 of July 13, 2026; order page prices of $385, $1,767 and $2,681 for the three licenses, all lifetime, on November 22, 2026. We didn't open our own workbooks with it.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License
Overview
HXTT Excel is a JDBC driver and a small database engine in one jar. Load com.hxtt.sql.excel.ExcelDriver, connect with a URL such as jdbc:excel:/c:/data, and each workbook in that folder becomes a set of tables, one per worksheet: "budget.xlsx".sheet1. Since May 2023, Named Ranges defined in Excel show up as tables too, so a range called Prices can be queried by name.
Real spreadsheets rarely have one neat header row. HXTT Excel can read multi-row headers, with headers and sub-headers both usable as column names (the firstRowHasNames and endRowHasNames properties set the header rows), recognizes several tables laid out side by side on one sheet, and can copy a merged cell's value into every cell of the merge for data migration. Column types are detected by scanning the first rows, and maxScanRows controls how many.
The engine runs embedded in your application or as a separate server. The DBAdmin tool in the jar starts, stops and monitors that server, and can run as a Windows service, a Unix or Linux daemon or a normal program.
DBAdmin, the server manager inside every HXTT driver jar, in an older Windows look. HXTT's sample shows one connection and its open table; this sample folder holds a DBF table, not a workbook.
Features
Read and write workbooks, formulas included
HXTT Excel supports INSERT, UPDATE and DELETE on worksheets as well as SELECT, and creates new workbooks in XLS, XLSX or Strict format with CREATE DATABASE. When you change a value, it recalculates the cells whose formulas depend on it, and since 2020 it can write formulas and cell styles (borders, colours, row heights) through SQL. A readOnlyMode property skips formula parsing when you only need to read, which is faster.
More than SQL-92
HXTT Excel supports nearly full ANSI SQL-92 plus many SQL:2008 additions: every join type, joins across several workbooks, UNION, INTERSECT and EXCEPT, all kinds of subqueries, common table expressions, GROUP_CONCAT, WITH ROLLUP and WITH CUBE, PIVOT and UNPIVOT, OFFSET and FETCH, and more than 230 SQL functions, with an API for your own. HXTT says GROUP BY, ORDER BY and DISTINCT work on full-size sheets of 1,048,576 rows without running out of memory.
Workbooks wherever they live
HXTT Excel opens workbooks from local folders, mapped drives and UNC paths, SMB shares (including Azure file shares), HTTP, HTTPS, FTP, FTPS and SFTP URLs, from inside ZIP, JAR, GZ, BZ2, 7z and TAR archives, from a Java InputStream, or as memory-only tables. A query like SELECT * FROM "testexcel.zip/files/a.xls".sheet1 reads a workbook inside an archive. Workbooks read over a URL are read-only.
Transactions, concurrency and security
HXTT Excel supports all four JDBC transaction isolation levels, multi-user access, thread-safe concurrent connections, connection pooling, DataSource, distributed transactions and RowSet. Security options are user and password checks, SSL connections, and DES, Triple DES, Blowfish and AES encryption at the SQL or database level.
Benefits
- No Excel on the server. The driver reads and writes the files itself, so it runs on Linux and in containers where Office can't.
- SQL instead of cell-walking code. Filters, totals and joins between sheets become short queries.
- Report and ETL tools just work. Anything that takes a JDBC driver, from Crystal Reports to DBeaver, can treat a workbook as a database.
- A perpetual license with a year of upgrades and support included.
Real-World Uses
- Importing supplier price lists: a Java service reads each supplier's XLSX from an SFTP folder and merges it into the product database.
- Spreadsheet-driven configuration: a web application reads rates or rules that business staff keep in a Named Range, so they can change them without a developer.
- Generating reports as workbooks: a nightly job creates an XLSX with CREATE DATABASE and fills it with INSERT statements for managers who live in Excel.
- Consolidating budgets: one query joins twenty departmental workbooks with two-row headers and totals them by cost centre.
Who It's For, and Who Should Skip It
HXTT Excel is for Java developers, integrators and DBAs who need SQL access to Excel files from server-side Java, report tools or ETL jobs, especially where Excel isn't installed.
Skip it if you don't write Java: it's a library, not a spreadsheet program. If you only need to read a simple sheet in your own code, a free spreadsheet API may be enough. On Windows with .NET or ODBC, a driver built for those platforms fits better. And if your workbooks are newer-format files with features beyond plain cells and formulas, test them in the trial before you buy.
Usage Guide
- Download the evaluation package (excel.zip) and unzip it. It holds the JDBC 3.0 jar, documentation and demo programs; the other JDBC packages are available after registering on HXTT's site.
- Add the jar to your classpath, for example
-cp Excel_JDBC30.jar, or put it in your application server's library folder.
- Load the driver
com.hxtt.sql.excel.ExcelDriver and connect with jdbc:excel:/your/folder for embedded use, or jdbc:excel://host:port/folder for a remote server.
- Query a sheet as
"file.xlsx".sheet1, or by a Named Range. Set firstRowHasNames and endRowHasNames for headers that span several rows.
- Open DBAdmin with
java -classpath Excel_JDBC30.jar com.hxtt.sql.admin.Admin to manage a server.
- Buy the license that fits how you'll deploy it before the evaluation period ends.
Where it falls short
- The trial is tight. The evaluation jar runs at most 50 queries per session, returns only the first 100 rows of a SELECT, and stops after 30 days, so judge speed on large sheets from HXTT's benchmark rather than the trial.
- Formulas aren't rewritten for you. HXTT notes that the driver recalculates dependent cells but doesn't adjust formulas when you delete the rows they refer to, which can give unexpected results.
- Listed formats stop at Excel 2016. Current Excel still saves XLSX, but features added since aren't mentioned in the documentation.
- Pricier than HXTT's CSV driver. $385 for one server; redistributing it in your own product needs the $1,767 license. Upgrades after the first year are a yearly renewal.
- Dated website and tools. The documentation is thorough but terse, and DBAdmin has an old Java look.
Comparisons
HXTT Excel vs a spreadsheet API such as Apache POI
A free spreadsheet library gives you full control over cells, styles and charts, but every query is code you write. HXTT Excel gives you SQL, joins across sheets and workbooks, transactions, and a JDBC connection other tools can use. Pick the API when you're building workbooks cell by cell; pick the driver when you're querying data that happens to live in Excel.
HXTT Excel vs the Microsoft Excel ODBC driver
The Microsoft driver only runs on Windows and needs a JDBC-ODBC bridge that Java 8 removed. HXTT Excel is pure Java, runs anywhere, reads multi-row headers and Named Ranges, and adds remote and compressed workbooks and a server mode.
Editions and Pricing
| License | Price | What it covers | Buy |
| Single Server License | $385 | Unlimited connections on a single server | Buy Single Server |
| 100 User Application License | $1,767 | Unlimited connections; redistribute 100 times with one commercial product | Buy 100 User |
| Enterprise License | $2,681 | Unlimited connections and servers, within one company in one country | Buy Enterprise |
Every license includes one year of free online upgrades and technical support by email and forum. HXTT offers bulk discounts on the order page.
FAQs
Does HXTT Excel need Microsoft Excel or Office installed?
No. HXTT Excel reads and writes the XLS and XLSX files itself in pure Java, so it runs on Linux, macOS and servers with no Office installed.
Can HXTT Excel read a sheet with a two-row header?
Yes. HXTT Excel detects headers and sub-headers between the rows set by firstRowHasNames and endRowHasNames, and both levels can be used as column names in SQL.
Does HXTT Excel calculate formulas?
Yes, within limits. HXTT Excel recalculates formula cells that depend on data you change, can write new formulas through SQL, and recalculates a whole workbook with FLUSH DATABASE. HXTT notes that SUMIF support isn't fully tested and that formulas aren't rewritten when rows they refer to are deleted.
Can HXTT Excel create a new Excel file?
Yes. HXTT Excel creates a new workbook with CREATE DATABASE: XLS (BIFF8) by default, or Excel 95 BIFF7, XLSX or Strict Open XML when you set the versionNumber connection property.
How big a spreadsheet can HXTT Excel handle?
HXTT Excel works on full-size sheets of 1,048,576 rows, and HXTT says GROUP BY, ORDER BY and DISTINCT on them run without OutOfMemory errors. Its PolePosition benchmark report is on HXTT's site.
Does HXTT Excel work with Hibernate, Tomcat and DBeaver?
Yes. HXTT Excel is a standard JDBC driver with DataSource and connection pooling, and HXTT's FAQ gives setup steps for Hibernate, Tomcat, JBoss, WebSphere, GlassFish, ColdFusion, DBeaver, JasperSoft Studio and Maven projects.
Which license do I need to ship HXTT Excel inside my own software?
To redistribute HXTT Excel with a commercial product, the 100 User Application License covers 100 copies of one product. The Single Server and Enterprise licenses are for running it on your own servers.
How do I get a refund?
Orders for HXTT Excel placed online are handled by 2Checkout, which accepts refund requests up to 30 days from the order date.
System Requirements
- Any operating system with a Java VM: Windows, Linux, macOS, Unix, Solaris, AIX, FreeBSD and others
- Java from Personal Java and JDK 1.0 through Java 14, with the matching JDBC 1.2 to 4.3 package
Conclusion
HXTT Excel is worth its $385 Single Server price if Java code on a server has to read, update or create Excel workbooks and you'd rather write SQL than walk cells. The reason to buy it is that it treats messy real-world sheets, with multi-row headers, Named Ranges and formulas, as database tables, with no Office anywhere, in a driver still updated with a July 2026 build. The reason to hesitate is cost: for simple reading inside your own code, a free spreadsheet library will do. Try it on a sample of your workbooks with the 30-day evaluation, keeping its 100-row limit in mind.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License