Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

reading DIRECTLY into a excel file

 
Pi Pomel
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, I'm new to this board. hope this hasn't been asked before.
how can I read into an excel file directly from java?
I know about the ODBC-JDBC bridge thing, but I would like to know if creating the ODBC data source (with the odbc administrator in the control panel) is feasible directly from java (i.e. without getting in the control panel etc...).
basically i want to give my java program a string "excelfile.xls" and to print the contents of the file whose name is this string.
hope the question is clear.
help would be very appreciated.
 
venugopal askani
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Pi,
Please refer to the following site http://matrix.psc.sc.edu/tutorials/jdbc/
Regards
Venu
Originally posted by Pi Pomel:
hi, I'm new to this board. hope this hasn't been asked before.
how can I read into an excel file directly from java?
I know about the ODBC-JDBC bridge thing, but I would like to know if creating the ODBC data source (with the odbc administrator in the control panel) is feasible directly from java (i.e. without getting in the control panel etc...).
basically i want to give my java program a string "excelfile.xls" and to print the contents of the file whose name is this string.
hope the question is clear.
help would be very appreciated.

 
Pi Pomel
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks, but in this tutorial, the step "setting up the spreadsheet as an ODBC datasource" is done by "Under Windows 2000, go to the Control Panel, select Administrative Tools, and click on Data Sources (ODBC)...". Now I would like to do this DIRECTLY from my java program. How can I do that?
 
charan Dhavile
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not able to access the site using the URL published by Venu . Any help ven?
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Take a look at Jakarta's POI. I think this is what you will benefit from most.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic