Any examples using HSSFDataValidation?

[Albert Park <Al...@oncomed.com>]

Hi,

 

I'm a newbie using poi version 3.0.2 and am having trouble with
HSSFDataValidation. I was wondering if there is any example code that
uses this functionality.

 

I am not sure how to access the object from a cell.

 

I create the HSSFDataValidation object like (pulled from a previous
email in the dev-mailing list):

String strFormula = "Lists!$A$1:$A$2";

HSSFDataValidation dval = new
HSSFDataValidation((short)0,(short)0,(short)1,(short)0);

dval.setDataValidationType(HSSFDataValidation.DATA_TYPE_LIST);

dval.setFirstFormula(strFormula);

dval.setExplicitListFormula(true);

dval.setSurppressDropDownArrow(false);

dval.setEmptyCellAllowed(true);

dval.setShowPromptBox(false);

sheet.addValidationData(dval);

 

How can I place the data validation in a specific cell, say A3 if that
row and cell have been created?

 

If someone could help me out, it would be really appreciated.