For a long time, APEX was Oracle’s Excel-killer. With the ability to upload a CSV file and create a matching table and then build an application on top of that, this was the easiest way to convert a spreadsheet into a secure multi-user application.
Visual Builder Cloud Service (VBCS) has now appeared as a serious challenger, offering some improvements over the way APEX handes Excel files. For example, the December 2017 version of VBCS has the ability to import Excel files directly without having to turn them into CSV files first. Separate worksheets in the Excel files become separate business objects. During the import, you can also define reference relationship for lookup values. This allows you to upload an Excel file with one master worksheet and a number of value lists as separate sheets, and produce a business object with all lookups in one operation. Read the complete article here.
For regular information become a member in the WebLogic Partner Community please visit: http://www.oracle.com/partners/goto/wls-emea ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.