Wednesday 4 December 2013

APEX Listener and Excel Upload

If you are using APEX Listener version 2.0, you can download a sample application here. In this application I am showing how to:

1. create an excel upload page
2. manage multiple excel sheets after upload

This new APEX Listener feature is great and I hope they will extend it to the other excel file formats - currently it works for .xls only. If you are using APEX 4.2.3 this will probably not work since there is a bug in that version of APEX.

So, the current limitations are:

1. xls files only
2. APEX 4.2.3 is buggy related to this feature
3. you can upload up to 49 columns since it is using APEX Collection and one column is used for excel tab names during the upload

In addition, you will need to add these four lines of code to the defaults.xml file:

<entry key="apex.excel2collection">true</entry> <entry key="apex.excel2collection.onecollection">true</entry> <entry key="apex.excel2collection.name">EXCEL_COLLECTION</entry> <entry key="apex.excel2collection.useSheetName">true</entry>



Enjoy.











4 comments:

Tobias said...

FYI, the latest patch release of APEX Listener (2.0.5) is supposed to handle xlsx files as well (haven't tried it):

http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25068/toc.htm#autoId11

Tobias said...

Sorry, link got messed up.

http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25068/toc.htm#autoId11

Denes Kubicek said...

Hello Tobias,

Thanks for the info. I will try that out.

Regards,

Denes

Unknown said...

Please
Tell me how to load the data into a database table?