Exactly what you did. Such a behaviour is likely for having some features (e.g. lists) or for having some corrupted file. The latter one you can prove if you build an Excel file from the scratch and look at the result then. In such cases this was the only way to have proper files again.
Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 12. September 2006 13:11 An: POI Users List Betreff: Re: AW: Opening an existing Excel spreadsheet I was using the 2.5.1 release and I just also tried the latest alpha build with the same results. What do you mean by doing a counter check? Thanks. Bryan N Oliver Systems & Software Engineer L.V. Lomas Limited [EMAIL PROTECTED] Phone: (905) 458-7111 ext 395 Cell: (416) 999-2377 Fax: ( 905 ) 458-3571 ----- Original Message ----- From: "KHZ (SAW)" [EMAIL PROTECTED] Sent: 09/12/2006 05:02 AM To: "'POI Users List'" <[email protected]> Subject: AW: Opening an existing Excel spreadsheet Hi Brian. Which version do you use? Possibly the file contains lists. Make a countercheck with POI 3.0. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Montag, 11. September 2006 20:31 An: [email protected] Betreff: Opening an existing Excel spreadsheet I am having a problem when I try and open an existing Excel file. ByteArrayOutputStream ba = null; FileInputStream fileInputStream = null; HSSFWorkbook hssfWorkbook = null; ba = new ByteArrayOutputStream(); fileInputStream = new FileInputStream( httpServletRequest.getSession().getServletContext().getInitParameter( "repReviewFile" ) ); POIFSFileSystem fs = new POIFSFileSystem( fileInputStream ); hssfWorkbook = new HSSFWorkbook( fs ); On this last line, I get this exception: rg.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:237 ) org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:16 0) org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130) Does anyone know why this might be happening. I have no protection or auto filters set on the file either. Thanks. Bryan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
