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
653 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,700 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,700 points
1,377 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,700 points
346 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,700 points
1,403 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,700 points
664 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,700 points
2,144 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,700 points
336 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,700 points
2,168 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