You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Sawant, Ramdas (IT)" <Ra...@morganstanley.com> on 2006/03/22 11:28:33 UTC
read unique values from the excel column
Hi all,
Can any one tell me how can we read only unique values from a
particular column of the Excel sheet. Thanks.
Regards,
Ramdas Sawant
........................................................................
Associate Consultant, Kanbay
Manikchand Ikon, South Wing 18 Dhole Patil Road
Pune 411001
INDIA
........................................................................
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.
RE: read unique values from the excel column
Posted by Tahir Akhtar <ta...@spectrum-tech.com>.
I am new to POI but AFAIK POI does not provide API to select values, search
etc from HSSFWorksheet. You may need to do it yourself.
You may also consider POI Formula evaluation. As formula evaluation is work
in progress, it may not have implementation for any such function.
I think following will work:
Loop over the rows
-Put the value of the column in a set
You will have to put value objects not the complete HSSFCell object. Rest is
upto the equals method implementation of values :)
Regards,
Tahir Akhtar
-----Original Message-----
From: Sawant, Ramdas (IT) [mailto:Ramdas.Sawant@morganstanley.com]
Sent: Wednesday, March 22, 2006 3:29 PM
To: poi-user@jakarta.apache.org
Subject: read unique values from the excel column
Hi all,
Can any one tell me how can we read only unique values from a
particular column of the Excel sheet. Thanks.
Regards,
Ramdas Sawant
........................................................................
Associate Consultant, Kanbay
Manikchand Ikon, South Wing 18 Dhole Patil Road
Pune 411001
INDIA
........................................................................
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.6/287 - Release Date: 3/21/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.6/287 - Release Date: 3/21/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/