Generate an Excel spreadsheet with a graph through Java

dshrenik
dshrenik used Ask the Experts™
on
Say I have 2 arraylists (or any other data structure) of numbers in Java, please let me know if I can automatically create an Excel file through Java with a graph that plots values from these 2 arraylists.

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2011
Awarded 2011

Commented:

Check Apache POI
http://poi.apache.org/

Author

Commented:
Please let me know if there are any tutorials or sample code for this.

Thanks!
Awarded 2011
Awarded 2011
Commented:
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Awarded 2011
Awarded 2011

Commented:


That was the solution in thea question
http://jxls.sourceforge.net/samples/chartsample.html

Author

Commented:
Ehich of jxls and Apache POI would you suggest considering licensing issues?
Awarded 2011
Awarded 2011

Commented:

It is like any open source, I was under impression, that all this stuff you can distribute with your product, but read here:
http://jxls.sourceforge.net/license.html

Mick BarryJava Developer
Top Expert 2010
Commented:
> Ehich of jxls and Apache POI would you suggest considering licensing issues?

POI does not even support charting so I'm not sure why it was even suggested
Mick BarryJava Developer
Top Expert 2010

Commented:
we've used jxls in the past, it does a pretty good job

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial