Sorting a Excel file using java

[kandan]

Hi,

My Requirement is... I have a dataset(Excel) file residing in mainframe and I have to get the file, Sort the columns(more than one) and then place the file into different path.
All I need to know is How can I sort the columns in the excel file using Java.

Thanks in Advance
Kandan.

[ractoc]

easiest way would be to create an ArrayList conraining all the rows, and then sorting that list. Aftedr sorting the list, create a new excel sheet in the other dir.