EXZELLENZ
EXZELLENZ 1.12 Build 39 for Windows
Christopher Ho
An intuitive application that enables you to modify, add or erase table data in an Oracle database file, through Microsoft Excel
EXZELLENZ is a Java-based software utility whose purpose is to make the interaction with an Oracle database file more comfortable via Microsoft Excel, being capable of recognizing both XLS and XLSX formats. However, considering that maintaining the files you are handling in Excel format is the only requirement, working with Open/Libre Office is also an option. The applicability of such a program revolves around the fact that uploading or downloading data from Oracle database is a routine many developers need to engage in once they have received Excel spreadsheets from the end users. However, the entire matter is, if not demanding, at least time-consuming, and resorting to a software solution such as EXZELLENZ could minimize the effort. Specifically, what the program offers to do is download data via an SQL query, upload it to a table, update as well as delete selected rows in Oracle tables without being bound to VBA macros or proprietary GUI. Manipulating table data by means of Excel files is thus more transparent, and this also confers more independence on end users, who can complete tasks without asking for assistance from developers. Apart from that, it is worth noting that the template can be adjusted so that it shows approachable designations for columns as well as worksheet layouts that users are able to interact with without difficulty.Features Pure Java implementation, platform independent. Support Microsoft Excel 97-2005 format (xls) and 2007 format (xlsx). Open Office friendly (as long as you save the file in Excel format). Five different operations: Template - create blank Excel worksheet with table or view definition. Download - download data from selected columns of a database table or view. User can specify "where clause" and "order clause" for the data. Upload - Insert data from Excel template to tables. Update - Update user-specified data changes in the Excel worksheet to database table. Delete - Delete user-specified row of data in Excel worksheet from database table Support both direct JDBC connection and EBS App DataSource connection. Language, EBS credentials, and responsibility can be specified if you want to download data from language-specific and org-ID specific views. Personalization allows hiding certain fields in the GUI so that business users can use this program without messing up the settings.

Software Summary:

You can run EXZELLENZ on Windows operating systems. EXZELLENZ is a software product developed by Christopher Ho and it is listed in the category. EXZELLENZ is licensed as EXZELLENZ.

Alternatives in on Windows