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]
