APEX

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

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:

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

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: test@test.com

PASSWORD: testtest

TABLE: MARKET

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

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

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

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

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

Thanks @"Carsten Czarski-Oracle" ! it helps !!