Do you mean drop down lists? Drop down menus are obviously different beasts entirely, more associated with naviagating around an application.
Anyway, cannot explain why you cannot read the file but have added to the discussion in the other thread a couple of examples of how to create drop down lists. V S P wrote: > > Hello > I am new to POI > > and figuring out if I can use it to create .xls with pulldown menues. > > I saw a similar question just posted recently but no answer an my > question ma be a bit different. > > > I assumed, may be incorrectly, that will not be able to create a > pulldown > menue, and instead I thought I would read a 'template' worksheet that > has a pulldown from my precreated excel file and then just copy it over > into memor, then add cells. > > So I used Open Office to create the template .xls with 2 workbooks > the first one to contain the cells with pulldown > the second one to contain the values for pulldowns > > clicked on a cell where I want the pulldown, added the control > and specified data for the pulldown control to come from a second > workbook > and saved it in OO as excel 97/2000 > > then I execute a sample program to just read the file > (found here http://sanjaal.com/java/?p=100 ) > > and I received an exception at > > new HSSFWorkbook(myFileSystem); > > > > org.apache.poi.hssf.record.RecordInputStream$LeftoverDataException: > Initialisation of record 0x205 left 1 bytes remaining still to be read. > at > org.apache.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.java:124) > at > org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:346) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:276) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:201) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:183) > at com.setrak.present.excel.UiExcel.readExcelFile(UiExcel.java:51) > at com.setrak.present.excel.UiExcel.main(UiExcel.java:31) > > > When I remove the cell with pulldown control the read works fine. > > > Therefore wanted to ask if what I am trying to do is 'supported' or if > not is there a workaround. > > Thank you in advance, > VSP > > -- > V S P > [email protected] > > -- > http://www.fastmail.fm - Choose from over 50 domains or use your own > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/-Q--reading-.xls-with-pulldown-list-tp23239168p23254141.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]
