Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

integrating MS Excel in a Java Program

 
Himangshu Guhathakurta
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!,
I want to write a program wherein the data submitted in the GUI frame can be mapped to MS Excel and draw bar graphs and charts.I have taken the input data to MS Access database but could not get to the excel files for charts..
I am new to java, so please help...
 
todd runstein
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First of all, keep in mind that "excel" is only available on windows. If you feel that you must read/write in xls format, check out the POI project: http://jakarta.apache.org/poi/

If you're just trying to make charts, don't tie yourself to an expensive application that some of your users won't have. Why not use JFreeChart instead: http://sourceforge.net/projects/jfreechart

Both of these projects are free and open source.
 
Casper Maxwell
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You may also check these JExcel tips:

http://www.java-tips.org/content/category/5/93/29/
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic