SYMPLiK EXZELLENZ is a program to manipulate table data in Oracle database by using a Microsoft Excel file (xls or xlsx format). Unlike Oracle WebADI, More4Apps, or other Excel-driven solutions, this program does not use Office VBA (macros) to process the data. It is a pure Java solution incorporated with Apache POI and the Oracle JDBC driver to download, upload, insert, update, and delete data from Oracle database tables. It is Linux-friendly for Open Office users as long as the spreadsheet is in Excel formats.
|Operating Systems||Windows Linux Solaris AIX|
|Implementation||Oracle PL/SQL Java|
|Translations||English Traditional Chinese|
Release Notes: This release adds an Oracle EBS connection mode, an EBS RunAs user mode, delete OPERATION_MODE, the ability to create template and download data from database views, and a parameter SAVE_NEW_FILE so that a new file will be created after a process. It adds a popup menu to select a file instead of drag-n-drop and to set the SAVE_NEW_FILE parameter.
Release Notes: Support for the Microsoft Excel 2007 format was added. The Excel Template version was changed to 1.3. POI version was changed to 3.6. Column width is automatically fit in the template and download operations. The active sheet is set in the template and download operations. The ROWID column is hidden in the download operation.
Release Notes: This release fixes an error when the date value is empty in DOWNLOAD mode. It fixes an Excel template version/program version conflict bug. It fixes an extra ROWID column added in DOWNLOAD mode. Known limitation: a template cannot be generated if the table has more than 255 columns (e.g. the OE_ORDER_LINES_ALL table has 240 columns).
Release Notes: The update operation mode was added. End users can make changes in the data rows downloaded from a database table and then update them back to the database.
Release Notes: This release adds a TEMPLATE operation mode to generate an Excel template worksheet for a table. It adds a DOWNLOAD operation mode to download table data of user-selected columns from Oracle to Excel worksheets. It adds UPDATE operation mode: after data is downloaded to Excel worksheet, a selected row of data can be updated back to an Oracle database table. POI has been updated from 3.2 to 3.5 beta 6. The Oracle JDBC driver has been changed to Oracle DB 220.127.116.11.0.