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, 2022 in Others by Kithuzzz
• 38,000 points
847 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, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Using excel I need to open PPT and create ".gif" image of a ."pdf" and save it

It appears happier if you get a ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,600 points
486 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

answered Jan 22, 2023 in Others by narikkadan
• 63,600 points
563 views
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, 2022 in Others by gaurav
• 23,260 points
955 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, 2022 in Others by gaurav
• 23,260 points
4,265 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, 2022 in Others by narikkadan
• 63,600 points
2,644 views
0 votes
1 answer

Convert Excel to PDF issue with documents4j

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

answered Sep 26, 2022 in Others by narikkadan
• 63,600 points
1,526 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, 2022 in Others by narikkadan
• 63,600 points
831 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, 2022 in Others by narikkadan
• 63,600 points
1,335 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, 2022 in Others by narikkadan
• 63,600 points
1,128 views
0 votes
1 answer

How to create page borders using Apache POI in excel files with Java?

Microsoft Excel cannot do this. Libreoffice Calc ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,600 points
1,052 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