My Oracle Support Banner

APEX Custom Application Data Load Wizard to Load Excel File (Doc ID 2610881.1)

Last updated on NOVEMBER 15, 2019

Applies to:

Oracle Application Express (APEX) - Version 18.2.0.00.12 and later
Information in this document applies to any platform.

Goal

Custom applications that are built with Data Upload capability, the Data Load wizard allows only CSV file upload.
There is no option for Excel file upload.

The uploaded file, or copied and pasted data, still needs to be comma separated or tab delimited. It's not possible to upload excel file. This has not changed even in APEX 19.1.

But the the data upload functionality in SQL Workshop in APEX 19.1 has been modernized with a new drag & drop user interface and support for native Excel, CSV, XML and JSON documents. The same capabilities have been added to the Create App from Spreadsheet wizard and a new, public data loading PL/SQL API is available. Note that this is ONLY about the SQL Workshop Data Load functionality and Create App from Spreadsheet wizard and NOT Custom Application Data load.

Is it possible to load Excel file using the custom application Data Load wizard?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.