Technical

Excel to Modern App in Apex Addendum: Websheets

In the previous posts (Part 1, Part 2 and Part 3) we took an Excel Spreadsheet and create a modern web-based application that our business users could do. Whilst it created a very powerful application, it did require us to know a little bit of SQL and was complex in parts. An alternative to a full-fledged application is to use the Websheets feature in Apex to create an editable web page that users can use to edit and manage their data. This can be a more appropriate option for converting spreadsheets as it is easier to use and doesn’t require any knowledge of SQL. However, because of this simplicity, it’s not as powerful a tool and may not be an option for more complex data interactions.

In this post we will take the spreadsheet we used in the previous posts and create a Websheet so we can compare the two methods. After that you’ll hopefully be able to choose the right option in future.

Continue reading

Technical

Excel to Modern App in Apex Part 3

In the last few posts (Part 1 on converting the spreadsheet to a database and Part 2 on creating the UI) we have built a functional web-based app out of our old excel spreadsheet. This application is now ready for business to use and make changes to, but we’d like to go a little further and create some graphs for the business users to look at. That’s actually pretty easy in Apex and what we will detail in this post.

Continue reading

Technical

Excel to Modern App in Apex Part 1

Oracle has a rapid development environment, Apex, that is very useful in replacing all those shared Excel files and Access databases running wild in your organisation. With it you can create modern HTML5 applications to replace all that business logic. To give you a better understanding of how it works and how you can use it within your organisation I’ve put together this series of posts where will take an Excel spreadsheet and create a usable application.

Our scenario is that the business has been using a spreadsheet to manage the sales for each of the regions. We’d like to modernise this app for a number of reasons:

  1. We want to be able to use the data in other applications. Whilst it is locked up in an Excel document this is impossible
  2. Since it’s a shared Excel document its not always clear if you have the latest version. This probably isn’t a major issue with our data set as its only changed quarterly, but a more complex Excel document will run into these problems
  3. The business wants to add more capability into the spreadsheet and wants IT’s help on this. By making it into a proper application this will be a lot easier to manage

Continue reading