Yes. That was the short answer Josh but it does seem to be what the OP is after. More specifically, he wants to be able to recover the values that are the basis for the data validation. Obviously, this could be either easy, if a simple list of values were provided, or more complex, if the values were derived from a formula so I am guessing that access to the formulae that are a part of the HSSFDataValidation (those that the setFirstFormula() and setSecondFormula() methods refer to) class would most likely suffice.
Must go now as I have a stack of cromes to sort out after yesterday. Yours Mark B Josh Micich wrote: > > Hello Naga & Mark, > > I've only skimmed over this thread so I apologise if this is not on topic. > > As far as I understand, the HSSF usermodel API allows data validations > to be added, but doesn't allow them to be queried (or removed for that > matter). > > In other words, we have the method: > void HSSFSheet.addValidationData(HSSFDataValidation) > > But perhaps we also need > HSSFDataValidation[] HSSFSheet.getDataValidations() > > Would something like this help with your current problem? > > cheers, > Josh > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/sample-code--to-read-excel-listbox-values-tp23921169p23976968.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
