Need to integrate Easy xlsx parser package with Data Loading Page component in Oracle Apex

3909339

I am using Oracle Apex 18.2. I need to upload Excel xlsx file using the Data Loading Page component in Oracle Apex, it should handle excel (xlsx) files while uploading on the Data Loading Page component in Oracle Apex. I tried using the Easy xlsx parser package by Carsten Czarski  but how can this be done within an application in the Data Loading Page component  as I need to map the columns as well and need to follow Data loading page component process?

Mahmoud_Rabie

Hi

Currently, in 18.2, you could only use XLSX_PARSER package which is written by @Carsten Czarski-Oracle here

https://blogs.oracle.com/apex/easy-xlsx-parser:-just-with-sql-and-plsql

However, it is available in easier and quicker way for Data Loading in 19.1 EA.

https://blogs.oracle.com/apex/quick-and-easy-data-loading-with-apex-191

I hope that helps

Regards

Mahmoud

3909339

Hi Mahmoud_Rabie,

I am following the blog (https://blogs.oracle.com/apex/easy-xlsx-parser:-just-with-sql-and-plsql ) but throws an error while I am creating/inserting data into the table. I am able to read the data on the report but while processing further for inserting the data into the table it throws an error. Any thoughts / suggestions on this? I have created a process on the Button to insert the data further into the table. I even tried selecting the option PL/SQL Expression and PL/SQL Function Body but nothing helps. Please find the below screenshot:

Carsten Czarski-Oracle

Hi,

two points ...

1. it's hard to impossible to debug the screen shot. You might want to create a test case on apex.oracle.com; which people can review, reproduce the error and then provide help

2. since apex.oracle.com has been upgraded to 19.1 last weekend, you might want to look into the new APEX_DATA_PARSER PL/SQL package coming with APEX 19.1. This includes the XLSX_PARSER functinality, but also a lot more. Here is a blog posting which contains some details: https://blogs.oracle.com/apex/super-easy-csv-xlsx-json-or-xml-parsing-about-the-apex_data_parser-package

Best regards

-Carsten

3909339

Hi ,

I have created a Workspace(TEST_FOR_XL) and have created an App.

I have created a page(2 - Import Excel - Without Wizard) based on your blog. Need your help to insert data into the table for the Page - 2.

Also, I have created Page 3 , Page 4 , Page 5, Page 6 using Page Component - Data Loading. I want to integrate the package to parse xlsx files and map it within the data loading process i.e. at the Page 3, Page 4 . Could you please help me integrate the xlsx parser package within the Page Component - Data Loading to parse xlsx files?

WORKSPACE: TEST_FOR_XL

APP: Test_For_XL

USER: [email protected]

PASSWORD: testtest

TABLE: MARKET

XLSX FILE:  https://ufile.io/qxf33

Let me know if anything else is required. Thanks in advance.

Carsten Czarski-Oracle

Hi,

1) You won't be able to "integrate" XLSX parsing with the built-in Data Loading wizard. You can use the APEX_DATA_PARSER (or XLSX_PARSER) API, but you will need to create your own wizard, then.

2) Could you add the code you have provided the screen shot above to the test case as well ... I probably don't want to type it in from the screen shot ...

Best regards

-Carsten

3909339

Hi @Carsten Czarski-Oracle,

1. Thanks for the suggestion.

2. I added the code of creating table in the dynamic action of the button. I am seeing the above error. Could you check now and let me know what needs to be fixed?

Thanks,

Ankit Gada

Carsten Czarski-Oracle

Hi Ankit,

have a look at page 2  ... in the "Processing" section you'll find the PL/SQL code inserting the data into your table.

regards

-Carsten

3909339

Thanks @Carsten Czarski-Oracle ! it helps !!