data validation field in excel

Question

Hi all, I want to know how to create a data validation field(list) in excel sheet through java code...Is there any method in jxl package that can create a data validation field.?

Answer 1

Check out the Java Doc for WritableCellFeatures. There are a few method in there that deal with Validation.

I think jxl.write.WritableCellFeatures.setDataValidationList(java.util.Collection c) is what you are looking for. If not, this should point you in the right direction.