how to download multiple view/table data in one excel from apex page by clicking button using application process(AJAX)
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Below is an example to download the CSV file using the Ajax process. To download the file in XLSX format, you need a third party package to convert the query result into the Excel format. The CSV file will also open in Excel.
Create a database procedure that will return the CLOB data type for the data return by the query having multiple tables:
Then create an Ajax callback process in Oracle Apex to call the above procedure and convert CLOB to BLOB and download. Add the following code in the Ajax callback text area:
Now you can call the above Ajax callback process on the button click as follows:
Where download_emp_csv is the Ajax process name.
suriya
Yes.. Thank you but how to add number of sheet in excel.. when downloading from apex on same format.
Vinish Kapoor
To generate an Excel file with multiple sheets using a database procedure, you will have to use any third-party PL/SQL utility. An example is given in the following post:
Export data into Excel from Oracle table using PL/SQL
Mubasher Ali
Hello Vinish
How are you.
How to pass Parameters Application Process Using URL
Like