Create Graph from data in an excel file

0 votes
In order to display a graph or chart based on the data, I need to extract the data from an excel file (.xls or.xlsx). Similar to Auto-filter in Excel, the presented graph or chart should contain filters or a mechanism that modifies it based on the selection made from there. More than six columns of data may be present in the excel file.

How do I go about it? Java is new to me. Thank you.
Oct 16, 2022 in Others by Kithuzzz
• 38,010 points
546 views

1 answer to this question.

0 votes

Your first step would be to become more familiar with Java itself, as you will need this foundation before you do anything else. Visit The Java Tutorials first and learn some of the basics. Once you've mastered the basics of Java, and understand GUI development, you can move forward to reading data from an Excel file. I recommend Apache POI as a great tool to read data from Excel.

Your next step is of course to learn about graphs and plotting in Java, here you might find something like JFreeChart of great help.

Everything said here is feasible and practicable in Java; it only depends on your degree of dedication and desire to devote some time to creating this solution.

If you choose not to develop your own system, why not use LibreOffice or Microsoft Excel instead? Both programs can open documents, extract data, and produce charts, and they both offer strong features that will meet your needs.

answered Oct 17, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

You can use OLEDB to create and ...READ MORE

answered Jan 3, 2023 in Others by narikkadan
• 63,420 points
1,218 views
0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Use AVERAGEIFS instead of the full range. ...READ MORE

answered Jan 14, 2023 in Others by narikkadan
• 63,420 points
292 views
0 votes
1 answer

How to represent the data of an excel file into a directed graph?

The pandas and networkx packages in Python ...READ MORE

answered Apr 9, 2023 in Others by narikkadan
• 63,420 points
1,125 views
0 votes
1 answer

Using Java to create PDF graphs based on Excel formulas

The Apache POI project, an API for ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 63,420 points
591 views
0 votes
1 answer
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,420 points
1,911 views
0 votes
1 answer

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

answered Jan 17, 2023 in Others by narikkadan
• 63,420 points
264 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,420 points
1,984 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