| 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.
|
|
 |
|
|
subject: Sorting a sheet by a column in POI
|
|
|
0
