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