With regard to the xml based files, I have had a very cursory dig around and cannot see a function that you could substitue for the data validation but I have thought of a possible alternative. Use Excel itself to create a workbook that contains the data validation and save it away as a template. Now, use POI to open the template file, populate it with data and then save it away again.
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-tp27402140p27407896.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]
