Using Java to create PDF graphs based on Excel formulas

0 votes

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.

 

Oct 21 in Others by Kithuzzz
• 20,660 points
75 views

1 answer to this question.

0 votes

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.

answered Oct 22 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
69 views
0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
1,874 views
0 votes
1 answer

Convert Excel and Word files to PDF Using ruby

 You can combine some: For excel files - ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
138 views
0 votes
1 answer

How to create and download excel document using asp.net

First, download the Open XML Format SDK 2.0. It comes ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
145 views
0 votes
1 answer

Java Spring - Writing Excel file and converting to PDF

Since you are using Spring I suggest ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
247 views
0 votes
1 answer

Convert Excel to PDF issue with documents4j

MS Excel may not always be used ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
189 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
40 views
0 votes
1 answer

How can I convert a Word document to PDF?

This is a difficult task, made even ...READ MORE

answered Oct 31 in Others by narikkadan
• 37,660 points
58 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
123 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP