Sorting a sheet by a column in POI

Ranch Hand

Posts: 45

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 47

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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)

Posts: 8791

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 45

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 70

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

There’s no place like 127.0.0.1. But I'll always remember this tiny ad:

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing