Link to home
Start Free TrialLog in
Avatar of tom_corc3
tom_corc3

asked on

How to read data into Excel

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)?
ASKER CERTIFIED SOLUTION
Avatar of Chad Smith
Chad Smith
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mberumen
mberumen

<ping>
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
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.