poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tahir Akhtar" <ta...@spectrum-tech.com>
Subject RE: read unique values from the excel column
Date Wed, 22 Mar 2006 10:43:33 GMT
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/


Mime
View raw message