This content has been marked as final. Show 8 replies
Yesterday I tried xls2collection with apex 4.1.1.00.23, Listener EA2, Glassfish, oracle 11.2 with excel 97-2003. After updating defaults.xml with
and going standard - file browse, button and xls2collection action - no success.
<entry key="apex.excel2collection">true</entry> <entry key="apex.excel2collection.onecollection">false</entry>
Maybe I missed some configuration steps in new configuration tree of EA2?
How much time does it take to load a larger Excel-sheet, say a couple of thousand rows, with this xls2collection? I'm working on an Apex plugin which can also load Excel sheets into collections, and I'm a little disappointed in the performance I get.
I've installed Apex Listener 1.1.4 Stand alone on my laptop with Oracle XE 11.2 and Apex 4.0
Loading a xls with two sheet, each wich 5000 rows with 3 columns takes with Apex Listener 35 seconds
Loading the same with my plugin takes 12 seconds.
But loading the same on apex.oracle.com takes almost 2 minutes.
Edited by: ascheffer on Nov 26, 2012 11:21 PM
some update on that
checked with listener apex_listener.126.96.36.199.14.25 and Application Express 4.2.1.00.08 no luck this time - still only xls works
but interesting is that sql developer 3.2.2 now support setting for excel (listener configuration) in 2.0 listener config.
So I believe there is only small step to bring it all to production release maybe 2.0.2 :-)