We help IT Professionals succeed at work.

How to read data into Excel

tom_corc3
tom_corc3 asked
on
I need to read an Excel spreadsheet (about which I know very little) into a Java application. Is there any cod e to do this? I would prefer not to use ODBC as I can't hard code the file name in advance - rather I would like to use a file chooser or type in a path in a text box.
Can I refer to the columns using their letters (column 'A', 'B' etc)?
Comment
Watch Question

Software Engineer
CERTIFIED EXPERT
Commented:
I did a quick search on google on came up with a few libraries that can help you.

extenTech extenXLS .9 beta -> http://www.extentech.com/products/ExtenXLS/docs/
Actuate Formula One for Java 9.0 -> http://www.f1j.com/home/default.jsp

Commented:
<ping>

Commented:
IBM's alphaworks has some beans to enable you to work with Excel in Java - try the ExcelAccessor bean suite.  Check out http://www-124.ibm.com/developerworks/oss/excel/index.html  Source code is available from IBM

Commented:
Also have a look in all the Java to COM bridging components. There is one from IBM (found also in AlphaWorks) and there is also JIntegra from www.linar.com, which is quite good (but cost $$) and has a demo of connecting to excel.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.