Using Java to create PDF graphs based on Excel formulas

Question

Here's what I'm trying to do:

1. Obtain 6 .txt files in Java (more or less depending on what I need)
2. Put them into excel document cells and allow a graph to sort the data (without bringing up the excel window, if possible)
3. Create a single-page PDF using the graph created in the excel document
4. Open PDF Viewer and show the PDF.

Any of this I have no idea how to do. I can handle #1 for processing the.txt file and how to enter data into cells because my knowledge of fundamental Java is good, but when it comes to creating the graph, I become lost.

If you don't know every single step, don't be afraid to post something; I'll just take things slowly.

 

Answer 1

The Apache POI project, an API for reading and producing Microsoft documents, is something I would consider.  Here's a link to its Excel assistance. However, I'm not sure if it will assist you with the graph.

Then you could take a look at the Apache PDFBox project.