jQuery in Action, 2nd edition*
The moose likes Java in General and the fly likes Sorting a sheet by a column in POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Sorting a sheet by a column in POI" Watch "Sorting a sheet by a column in POI" New topic
Author

Sorting a sheet by a column in POI

Radha MahaLakshmi
Ranch Hand

Joined: Mar 28, 2003
Posts: 45
Hi All

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.

Thanks and Regards
Radha
Ashish Vegaraju
Ranch Hand

Joined: Aug 19, 2004
Posts: 47
hi,

i too worked on POI, but i m not getting what u want to say..can u explain it in detail?
Ashish.
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
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
Radha MahaLakshmi
Ranch Hand

Joined: Mar 28, 2003
Posts: 45
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.

Regards
Radha
Karthikeyan Rajendraprasad
Ranch Hand

Joined: Apr 16, 2003
Posts: 70
no direct method is there i hope. instead you can write a simple ascending/descending order program base on the column type.


Karthikeyan<br />SCJP 1.4, SCWCD.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sorting a sheet by a column in POI