Can I ask which file format you are targetting please? Are you creating binary workbooks (.xls) or xml ones (.xlsx)?
If the former, then I would recommend that you look at using data validations - and the org.apache.poi.hssf.util.HSSFDataValidation class. This page should give you all the information you need to get started - http://poi.apache.org/spreadsheet/quick-guide.html#Validation. Sadly, if you are targetting the latter file format, then I do not believe that this feature has yet been introduced but I am confident that you can use a function to constrain the values the user may enter. If I have the time, I will take a look tonight and see what I can find; if anything turns up, I will post to the list. Yours Mark B hima bindu-2 wrote: > > Hi, > > I have the following requirement: > > Suppose there is a column called Id in Excel Sheet. I need to provide some > data validation for that column so that only unique values can be entered. > > Id > 1 > 2 > 3 > 4 > . > . > . > > Can some body suggest the possible approaches? > > -- > With regards, > B.R.Hima Bindu. > > Stephen > Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html> > - "I detest life-insurance agents: they always argue that I shall some > day > die, which is not so." > > -- View this message in context: http://old.nabble.com/Unique-value-for-a-column-in-a-Excel-tp27402140p27406706.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]
