Download version 2.1 from Github (2022-11-14)
Download version 1.12 from Sourceforge
Upload and download data from Oracle database are the most common tasks performed by developers every day. More often is that end users provide data in Excel spreadsheet and then ask developers to do the upload for them. If it is a routine case, developers can create a SQL*Loader control file, use the data import function in TOAD, or write a simple program to handle this task. What happens if the table or column definitions have changed? If the developers are busy or not available, is the end-user able to handle the data upload by themselves?
EXZELLENZ provides a simple solution to manipulate table data through Excel files. A pure Java program, it can upload, download, update, and delete data in Oracle table without using complicated VBA macro or proprietary program interface. Developers can handle the data much more easier, and more importantly end users can handle the data without the help from developers once the Excel template has set.
Features
- Able to handle 97-2003 Excel file formats (.xls) and 2010-201x Excel formats (.xlsx)
- Able to work with 32bit or 64bit Excel programs. It does not use VBA add-on so it also works for OpenOffice / LibreOffice in Linux environment as long as the file is in Excel formats.
- Functions include:
- Upload data to table
- Download data from table with selected columns
- Download data using a SQL query
- Update or delete data for selected rows
- Template can be customized to use user-friendly column name or worksheet layout so that end users can understand it more easily.
- Allow connection to 11i or R12 EBS database using specific language, user and responsibility so that it can access org-specific, language-specific or security-enabled views or functions.