Hi Kevin, I couldn't create an Instance of HSSFWorkbook when the excel have drop downs using poi 2 or 2.5. What I did was: eliminate all drop downs from the excel and create a macro to build all drop downs, this macro run on "open" event of the thisWorkbook object, that way I could create the HSSFWorbook instance. Maybe you need also add another macro to eliminate the drop downs from sheets into "before close" event.
If you need a sample file I can send you one; just let me know. -----Original Message----- From: Kevin Keith [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 5:54 AM To: [EMAIL PROTECTED] Subject: Unable to open Excel workbook: org.apache.poi.hssf.record.RecordFormatException Hi, I'm trying to open an existing Excel workbook which has many macros, colour, drop-down lists etc as a template. At step-3, constructor throwing an exception: Please let me how to fix the problem. Thanks in advance Kevin Code: Step -1 : File File1 = new File(PropertiesReader.getAbsolutePath()+"/XYZ.xls"); Step -2 : POIFSFileSystem fs =new POIFSFileSystem(new FileInputStream(File1)); Step -3 : wb = new HSSFWorkbook(fs, true); Step -4 : HSSFSheet sheet = wb.getSheetAt((short)3); Exception: org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:237 ) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:16 0) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) at com.quality.group.report.PSCReport.genReport(Report.java:71) at servlet.report.PSCReportServlet.genReport(ReportServlet.java:76) at servlet.report.PSCReportServlet.doPost(PSCReportServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:711) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:687) at java.lang.Thread.run(Thread.java:536) } __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
