I need to extract data from an excel for furtha processing. I am using POI to extract the data and i could able to do it successfully. I want to know is there any way we can sort the sheet by a column through POI.
As an alternative approach, on Windows you can open a spreadsheet as a database and a named range as a table with JDBC-ODBC drivers. You should be able to do a standard query with order by in that case.
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Joined: Mar 28, 2003
Hi Thanx for the reply. My application needs to be deployed on UNIX.
Is there anyway i can sort on a column of spread sheet through java using POI.