Java, transfer excel cell contents into array

[ckwolfe]

I have created a "numbers" file (mac version of excel) of titles that is not in abc order and wish to put it in abc order from a program i have created in java. The only problem is the list has over 500 elements so doing it manually would take ages. Is there a way to read in the contents of each cell into an array so i can just sort the array and return it back to the numbers program without inputing each cell content manually? Thank you for any help.

Cory

 

[Markbnj]

You can just use Excel to sort the rows based on that column.

 

[EvilManagedCare]

An alternative if for whatever reason you didn't sort it in Excel itself as Markbnj suggested, is to store the files in one of the Java Collections and use class Collections static sorting methods to alphabetize. If they are not being stored as String or some other data type included in Java, though, you will need to implement the Comparable interface for the data type iirc.

Mark's way is easier though.