Can I Import Excel Worksheet to Java and Sort By Cell Info -

Can I Import Excel Worksheet to Java and Sort By Cell Info -

i know if through java can compare values in columns seperate out each person's name , farther seperate out largest number in column b be.

so want find best time each runner

i understand if question possible , little bit how.

say have excel spreadsheet column has name of participants of track team. these names repeated multiple times.

column b has run times in seconds of each runner throughout season.

column c has date of time.

a b c john 20 1/26/2012 john 18 1/27/2012 john 17 1/28/2012 cindy 21 1/26/2012 cindy 20 1/27/2012 cindy 18 1/28/2012

if export excel file csv may:

load bufferedreader split each line of text array of string string.split( ";" ) convert column b integer integer.parseint() convert dates sortable yyyy/mm/dd string.split( "/" ), concat [2]+[1]+[0] make instance of person (a user defined class) name, time , date add person list sort list want user defined comparator

java excel