To the experienced:
In my work I need to read from Microsoft Excel .xls files, which I never did before. Searching on the web I found and downloaded the jxl library (jxl-2.6.3.jar from http://www.findjar.com/jar/net.sourceforge.jexcelapi/jars/jxl-2.6.3.jar.html) and tried to use it in JDeveloper 11.1.1.3. I put that jar file c:\oracle\middleware\jdeveloper\lib, and in the test java class file used
import jxl.*;
But JDeveloper does not find the library. I then put the jar file also in ...\jdeveloper\ide\lib, ...\jdeveloper\jdev\lib, which did not work out either. So if anybody know this is done, could you please let me know?
Also, I am not sure if jxl is good. I also see on the web that some people use Apache org.apache.poi. Which is better? I need to read files containing many columns and thousands of rows.
Thank you very much for your help!
Newman