Converting your Spreadsheet into a Cloud App using Oracle APEX

Indian Students List 

Spreadsheets are great for storing data, but as data grows, managing, searching, and visualizing it becomes difficult. Oracle APEX makes it easy to transform spreadsheets into powerful, secure, and scalable cloud applications—without heavy coding.

In this blog, I share how I converted an Excel spreadsheet into a fully functional Oracle APEX Cloud App, following the official Oracle LiveLabs steps and guidelines.

Reference Workshop (Oracle LiveLabs):
https://livelabs.oracle.com/ords/r/dbpm/livelabs/view-workshop?wid=631

This implementation closely follows the structure, best practices, and flow explained in the above LiveLabs workshop.

What This Blog Covers

Using Oracle APEX, I converted an Excel file into a cloud application with:

  • Dashboard

  • Interactive Report

  • Faceted Search

  • Calendar View

  • Map View (India-based data)

The data source used is an Excel file containing India School Students List.

Now, lets get into a breif where 

Step -1 :

Uploading the excel sheet into oracle APEX ro create a application with the datas provided and adding the needed values, names, logo and icons to it.

First the application comes with a dashboard with bar chart and pie chart




Step -2 :

Now, It has a report classic report with faceted search were it has the filter options to serach among those 400 to 500 set of datas on the excel to get a accurate set of results and a quick results on the same time.


Step 3 :

At third it is a normal interactive report, which has its inbuilt actions to be performed and that can be saved on the same way, quite a normal report with all its inbuild functions, I have not done anything on extra it just has eveything on its own.


Step 4 :

Now, It's not come attached while creating the application has the previous one. we have to create a map on a blank page and then need to add all the steps given on the video as I already shared the link with you on the starting of the blog, so now will share the image of the map which I have created using the names of the students and I have separated them has male and female and with unique colour for there gender 


Also, I have created a same set of application using employee details and seperated there regions in different colours based on there salary, will also attach that application site page for your reference,



Conclusion

By following the Oracle LiveLabs workshop steps, I successfully converted an Excel spreadsheet into a complete Oracle APEX application with dashboards, reports, calendar, and map views.

🔗 Official Workshop Reference:
https://livelabs.oracle.com/ords/r/dbpm/livelabs/view-workshop?wid=631

If you’re working with spreadsheets and want to modernize them into web applications, Oracle APEX is the perfect tool.

These all are the content I have created using the workshop and learned to do the same on oracle APEX, as I have shared the link with you guys do the same and have a happy learning.


Comments

Post a Comment

Popular posts from this blog

Building a Wizard-Based Application in Oracle APEX

Image
Oracle APEX Wizard Application In this blog, I’ll walk you through a Wizard-Based Application developed using Oracle APEX , designed to collect user information step by step in a structured, secure, and user-friendly manner. Wizard applications are ideal when data needs to be entered in a specific sequence, ensuring accuracy and improving the overall user experience. Home Page – Wizard Overview Key Highlights: The Home page acts as an introduction to the application and clearly explains the purpose of the wizard. Clean and professional layout Clear explanation of each step in the wizard Visual icons for better understanding A Start button to begin the process Wizard Steps Explained: Step 1: Tax Information Collects the user’s Tax ID for identity validation. Step 2: Bank Details Captures Bank Name, Account Number, and IFSC Code. Step 3: Document Upload Allows users to upload documents like Aadhaar and Passport. Step 4: Review Users verify all entered de...
Read more

Payment Gateway in Oracle APEX using Razorpay

Image
   Razorpay Payment Gateway Integration in Oracle APEX (Step-by-Step Guide) In this blog, I’ll show you how to integrate Razorpay and PayU payment gateways in your Oracle APEX application — similar to my Stripe payment gateway blog. You’ll get step-by-step instructions to implement both gateways, from obtaining API keys to processing payments inside Oracle APEX. 👉 I also have a YouTube video demonstrating the Razorpay integration you can check here: https://youtu.be/T9OyXVbBlPQ YouTube Razorpay Payment Gateway Integration in Oracle APEX Step 1: Create a Razorpay Account Go to https://razorpay.com   and sign up for an account. Navigate to the Dashboard → API Keys . Generate your Test API Key ID and Secret Key (you will replace these with Live keys later). Step 2: Create Required Database Objects Before integration, set up tables and procedures to store order/payment data. Upload your SQL scripts via: SQL Workshop → SQL Scripts → Upload & Run Created page item...
Read more