HXTT Excel 5.0.016

HXTT Excel is a comprehensive Windows software that offers the most extensive range of JDBC driver packages (including versions 1.2, 2.0, 3.0, 4.0, 4.1, 4.2, and 4.3) for Microsoft Excel, spanning from older versions like 95, 97, and 2000 to the latest editions such as 2016 and the Strict Open XML format. This software supports various modes, including transactional access, embedded access, remote access, client/server mode, memory-only database, and access to compressed databases in formats like .ZIP, .JAR, .GZ, .TAR, .BZ2, .7z, .TGZ, .TAR.GZ, and .TAR.BZ2. It also facilitates accessing Excel files stored on SAMBA servers and URL databases via protocols like HTTP, HTTPS, FTP, and SFTP. HXTT Excel leverages an embedded Pure Java database engine, enabling deployment and accessibility of MS Excel databases on any platform that supports JVM.

The distinguishing features of HXTT Excel make it a highly advantageous choice for users. The software excels in performance, offering high speed and efficiency with a small memory footprint that prevents OutOfMemory exceptions. Its transactional-oriented database engine enables both embedded and client/server modes suitable for mobile systems. HXTT Excel supports all types of joins, including INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, and CROSS JOIN, along with essential SQL operations such as GROUP BY, ORDER BY, and DISTINCT. It can handle vast spreadsheets with up to 1,048,576 rows, delivering faster speeds compared to many other databases. The software also provides a benchmark report in PDF format for offline reference.

Recognizing the complexities of Excel headers, HXTT Excel offers seamless header recognition, allowing direct usage of headers and sub-headers as column names in SQL queries. It can efficiently handle parallel tables as well, expanding the range of possibilities for data manipulation and analysis.

HXTT Excel extends beyond the SQL92 standard, supporting nearly the complete ANSI-92 SQL (BNF format) and incorporating numerous enhancements from SQL:2008. With over 230 SQL functions, open user-defined SQL function API, compatibility with XOPEN SQLState, RMI, Jini, JNDI, and serialization, this software ensures comprehensive SQL capabilities. It enables advanced query operations such as {UNION | INTERSECT | EXCEPT | MINUS} [ALL] queries, multiple-row VALUES tables, PIVOT tables, UNPIVOT tables, and subqueries encompassing single-row, multirow, multiple-column, inline views, and correlated subqueries. HXTT Excel seamlessly handles join queries across multiple XLS (XLSX) databases, and it supports data mining on memory-only tables, physical tables, URL tables, SAMBA tables, and compressed tables within a SQL environment.

HXTT Excel provides flexible data access modes, including embedded mode, client/server mode, and remote access options via various protocols such as mapping network drives, SAMBA, HTTP, HTTPS, FTP, SFTP, and UNC paths. Data security is a top priority, with support for user/password verification, SSL-encrypted connections, and customizable connections. The software offers encryption algorithms like DES, TriDES, Blowfish, and AES at both the SQL and database levels, ensuring secure data storage and transmission.

Transaction support in HXTT Excel encompasses all levels of transaction isolation, including READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. This enables consistent and reliable data management.

To facilitate concurrent database connections and ensure thread safety, HXTT Excel provides robust support for concurrent connections. It allows multiple users to access the database simultaneously, maintaining data integrity and enhancing scalability.

HXTT Excel's type 4 JDBC drivers are entirely written in Java, making them platform-independent and deployable on any Java VM-supported platform, including Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, SCO Unix, UNIX, and LINUX.

The software seamlessly handles files and directories within ZIP, GZIP, BZ2, 7z, and TAR files, supporting easy integration of data stored in these formats. It also enables direct access to databases via HTTP, HTTPS, FTP, and SFTP URLs, expanding the range of accessible data sources. Furthermore, HXTT Excel allows smooth integration with SAMBA databases through SMB URLs.

HXTT Excel supports memory-only databases, allowing users to process internal data, applets, or specific applications efficiently in a memory-based environment. Additionally, it can read databases from standard or compressed java.io.InputStream objects, providing flexibility in data source options.

With compatibility spanning various Java versions, HXTT Excel supports Personal Java, JDK versions 1.0.X to 1.8.X, Java 9, Java 10, and Java 11. It also supports different JDBC versions (1.2, 2.0, 3.0, 4.0, 4.1, 4.2, and 4.3), along with essential features like connection pooling, DataSource, distributed transactions, and RowSet. The software seamlessly integrates with popular development tools, databases, and frameworks, including Borland's BDE, Borland's Database Desktop, JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, iSQL-Viewer, AquaDataStudio, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, Crystal Reports, Jisql, RazorSQL, and DbEdit Database Utilities for Eclipse Platform.

HXTT Excel ensures internationalization support, leveraging the Unicode, locales, and encodings supported by the JVM. It goes beyond the standard JVM offerings by additionally supporting Cp895 (Czech MS-DOS 895), Cp620 (Polish MS-DOS 620), and Mazovia encodings.

For client/server mode, HXTT Excel provides a graphical user interface (GUI) database server manager with remote control capabilities. This feature allows convenient management of the database server and can be operated as a Windows service, Unix/Linux daemon, or standalone application.