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 in Others by Kithuzzz
• 20,660 points
42 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 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
145 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
248 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

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

Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
107 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 in Others by narikkadan
• 37,660 points
82 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
272 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 in Others by narikkadan
• 37,660 points
243 views
0 votes
1 answer
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