Creating an Application Express Database Application from a Spreadsheet

 

Before You Begin

Purpose

In this tutorial, you learn how to create a Database Application in Application Express from a spreadsheet.

Time to Complete

Approximately 15 minutes

Background

Oracle Application Express provides a functionality to create a desktop application based on a spreadsheet data. This can be done by selecting From a spreadsheet in the Create Application Wizard.

What Do You Need?

  • Oracle Application Express workspace

  • Spreadsheet to create the database application - The tasks.txt spreadsheet is used in this tutorial.

 

Creating an Application from Spreadsheet Data

  1. On the Workspace home page, click the App Builder icon.

    App Builder icon in Application Express 5.1
    Description of this image

  2. Click the Create button.

    Create button in Application Express 5.1
    Description of this image

  3. In the Create an Application modal window, select From a spreadsheet.

    Create an Application modal window
    Description of this image

  4. For Load Method, select Upload file, comma separated (*.csv) or tab delimited and click Next.

    Create an Application From Spreadsheet: Load Method
    Description of this image

  5. For Data, click Choose File, navigate to the spreadsheet (or CSV) file, and click Open. Enter \t for Separator, ensure that "First row contains column names." checkbox is enabled, and click Next.

    Create an Application From Spreadsheet: Data
    Description of this image

  6. For Table Properties, select HR for Schema and enter TASKS for Table Name. Review the table properties and click Next.

    Create an Application From Spreadsheet: Table Properties
    Description of this image

  7. For Application Options, accept the default for Application Name and Report Type and click Create Application.

    Create an Application From Spreadsheet: Application Options
    Description of this image

  8. The application is created successfully.

 

Executing and Reviewing the Application

  1. On the Application home page, click the Run Application icon.

    Run Application icon
    Description of this image

  2. Enter your login credentials and click Log In.

    Tasks Application: Log In page
    Description of this image

  3. The home page of the TASKS application, containing the interactive report, is displayed. Click the Edit icon in the first row.

    Tasks Application home page
    Description of this image

  4. The modal window to edit the Tasks entry appears. Change the value for Cost and click Apply Changes.

    Edit Tasks modal window
    Description of this image

  5. The Cost has been updated. Now you create a new Task. Click Create.

    Tasks Application home page: Create Task
    Description of this image

  6. Enter details for the new task and click Create.

    Create Task modal window
    Description of this image

  7. The new task is successfully created. You will be able to see the new task in the Interactive Report.

    The new task in the Interactive Report
    Description of this image
 

Want to Learn More?