The feature is documented briefly in Export Oracle Application Express, the Apex Listener chapter.Right, I forgot that parts of the APEX Listener usage are referenced in the APEX docs. Unfortunately, these references seem to be written into the documents based on early roadmaps and were published without reviewing them against the actual production release. The APEX 4.0 Install Guide for instance has a section on [url http://docs.oracle.com/cd/E17556_01/doc/install.40/e15513/pre_require.htm#HTMIG381]HTTP Server Requirements that refers to the APEX Listener as follows
Oracle Application Express Listener is a Java-based Web server. It features file system caching, support for FOP transformations to PDF, offers improved file upload capability, and is certified against Web Logic, Tomcat, and OC4J with Oracle WebLogic Server, OC4J, and Oracle Glassfish Server.The thing is, though Kris developed on Tomcat, Oracle decided to drop official support for non-Oracle products and you won't find anything about Tomcat in any document on APEX Listener any more. This was different in the EA stage of the development. Also, the APEX Listener didn't get the FOP integration that was announced. The XLS import is another bullet on that list.
Oracle Application Express Listener is a Java-based Web server. It features file system caching, offers improved file upload capability, and is certified with Oracle WebLogic Server, Oracle Glassfish Server, and OC4J.Probably the APEX 4.0 documents had been finished long before the decisions on the feature cut in APEX Listener had been made, because the APEX release was to be released earlier. My guess is that APEX Listener only got minor priority on finishing within the initial schedule and finally failed to do so.
I hope that Kris gets a windows to work on this one!It seems as if that feature had almost been completed, but I guess other projects (most likely SQL Developer) got the focus. With a bit of luck, APEX Listener will be next in line and then finally gets the features that had been planned for the initial release...
note that in the NEXT release of the APEX Listener, the XLS2COLLECTION upload will word.That's great news! Personal contacts are really priceless. ;)
I met up with Kris at RMOUG 2012 and confirmed this.
Col_A Col_B C 1 2 C2 2 2 C3 3 2 C4
Column_A Column_B Column_C 3.9 2.1 3.2 1 2 2.1 3.1 2 2.5
h3. APEX Listener Configuration
h3. APEX Page items
<entry key="apex.excel2collection">true</entry> <entry key="apex.excel2collection.onecollection">false</entry>
Sequence Collection Name C001 C002 C003 C004 C005 1 P10_FILE_BROWSE:SHEET1 Sheet1 Col_A Col_B C - 2 P10_FILE_BROWSE:SHEET1 Sheet1 1 2 C2 - 3 P10_FILE_BROWSE:SHEET1 Sheet1 2 2 C3 - 4 P10_FILE_BROWSE:SHEET1 Sheet1 3 2 C4 - 1 P10_FILE_BROWSE:SHEET2 Sheet2 Column_A Column_B Column_C - 2 P10_FILE_BROWSE:SHEET2 Sheet2 3.9 2.1 3.2 - 3 P10_FILE_BROWSE:SHEET2 Sheet2 1 2 2.1 - 4 P10_FILE_BROWSE:SHEET2 Sheet2 3.1 2 2.5 - 1 P10_FILE_BROWSE:SHEET3 Sheet3 Something - - - 2 P10_FILE_BROWSE:SHEET3 Sheet3 different - - -