If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Oracle APEX and Excel Macros

Oracle APEX Application that relies on Excel Workbook Macro to perform certain functions. This combined application must then run in Oracle cloud, so that users can access it.

I am new to Oracle, and would greatly appreciate help with:

(a) with a pl/sql procedure that selects columns from the two data tables,
(b) put them in one .xlsx file in a directory,
(c) open .xlsm separate workbook that auto execute the macro and
(d) store the processed data back in new data tables in APEX application for interactive reports and dashboard display?