Searching in excel sheet using java basic script

Question

I am not sure how to go about with the task. so i'll just elaborate the things i need/want in this scenario..

I want to search a record in the excel sheet based on some criteria( 4 criteria specified)
so based on it i may find 4 to 5 records matching the criteria. I want to display these records row by row in the search window itself ( like adding a excel object if i'm not wrong)
Then when i click a particular record from the search result in the search window, the complete details of tat record should be displayed in the main screen (i.e it should retrieve the entire record from excel sheet into the GUI console.)

This is the task. Any idea how to do it? If the excel rows can be added as excel object, then how do i do it? any tutorials..suggestion would be very helpful.

By the way iam using java swing and excel sheet as backend.

pap · Accepted Answer · 2012-08-28 08:08:32Z

1

Apache POI is a popular framework for working with Office files (word, excel, powerpoint). Check it out.

answered Aug 28, 2012 at 8:08

pap

27.7k6 gold badges44 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dan D. · Accepted Answer · 2012-08-28 08:09:54Z

0

In order to read Excel documents in Java, I suggest you use a third-party library like Apache POI.

You will have to read the records from the Excel and probably create instances of your own model for these records. Build some model logic for searching based on the criteria. Put the ones matching the criteria into a JTable model.

Handle mouse events or selection events in the table and use your model again to located the selected record and display the full record where you have to.

answered Aug 28, 2012 at 8:09

Dan D.

32.4k6 gold badges66 silver badges81 bronze badges

Comments

Olivier Coilland · Accepted Answer · 2012-08-28 08:12:11Z

0

It looks like you need some lib to read and search Excel files on the fly in Java.

I recommend using Apache POI.

Have a look at the Quick Guide and Getting the cell contents.

answered Aug 28, 2012 at 8:12

Olivier Coilland

3,11618 silver badges20 bronze badges

Collectives™ on Stack Overflow

Searching in excel sheet using java basic script

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related