• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

integrating MS Excel in a Java Program

 
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...
 
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.
 
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/
 
The harder I work, the luckier I get. -Sam Goldwyn So tiny. - this ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic