poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: sample code to read excel listbox values
Date Mon, 08 Jun 2009 14:56:51 GMT

Sorry to say this but I do not think this is possible.

Excel uses data validations to check the values users enter into cells and
to offer then a list to select a value from. It is possible only with HSSF
to create data validations using the HSSFDataValidation class but I cannot
find in the javadoc any method that recovers a data validation from a
workbook, sheet or cell.

I could very well be wrong and will have a play with some code this evening
to see if there is anything I can do. If I find any more information, I will
post again.


Mark B

Nagineni wrote:
> Hi,
> I'm new to POI.I learned reading excel data from java using POI.
> I'm not able to find the way to read list box vlues from the excel
> sheet.Could any one provide me the sample code to read excel sheet list
> box values so that I can dig into more?
> I'm helpless from my google search.Please do help me.
> Regards,
> Naga.

View this message in context: http://www.nabble.com/sample-code--to-read-excel-listbox-values-tp23921169p23925649.html
Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message