Sorry to say this but I do not think this is possible. Excel uses data validations to check the values users enter into cells and to offer then a list to select a value from. It is possible only with HSSF to create data validations using the HSSFDataValidation class but I cannot find in the javadoc any method that recovers a data validation from a workbook, sheet or cell.
I could very well be wrong and will have a play with some code this evening to see if there is anything I can do. If I find any more information, I will post again. Yours Mark B Nagineni wrote: > > Hi, > > I'm new to POI.I learned reading excel data from java using POI. > > I'm not able to find the way to read list box vlues from the excel > sheet.Could any one provide me the sample code to read excel sheet list > box values so that I can dig into more? > > I'm helpless from my google search.Please do help me. > > > Regards, > Naga. > > -- View this message in context: http://www.nabble.com/sample-code--to-read-excel-listbox-values-tp23921169p23925649.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]
