OHS, EPG, and APEX Listener Compared - Expert Oracle Application Express - page 65

So how do you do it? Well, first of all, you need to configure some extra options in the apex-
config.xml file for the APEX Listener to support the Excel uploads. You need to add these lines to the end
of your configuration file if you don't already have them (these features are not available through the
GUI configuration so you need to edit the file directly and restart the APEX Listener).
<entry key="apex.excel2collection.onecollection">true</entry>
<entry key="apex.excel2collection.name">EXCEL COLLECTION</entry>
<entry key="apex.excel2collection.useSheetName">true</entry>
<entry key="apex.excel2collection">true</entry>
The settings I have made here mean that the Excel file will be placed into an APEX collection called
EXCEL COLLECTION (I could have used any name); also, the parsing routine will use the worksheet name
rather than a generic iterative name.
Now you can create a simple APEX application to demonstrate how to perform the upload. First,
you need to add a File Upload item, as shown in Figure 1-37.
Figure 1-37. File upload item
Notice that I have chosen Table WWV FLOW FILES as the storage type, since I am not really interested
in storing the uploaded file in my own table in this demo (it simplifies the example since I don't need to
create my own table, etc.).
The next step is to add a button to submit the page, thereby uploading the file, as shown in Figure
1-38.