Thanks for a prompt response. Yegor, we'll definitely try version 3.8-beta4 both inside Oracle environment and isolated as a separate application. Thanks for your input.
Nick, do you know if this problem could be due to the encoding logic as stated in http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-48936-New-Writing-specific-sequence-of-strings-to-XSSFSheet-results-in-malformed-XML-td2339732.html and if so is there any known workaround. There is a possibility that the file may be corrupt, but I have no problems getting a blob from the database and opening it in excel. The workbook is created as follows: Workbook wb = WorkbookFactory.create(conn.getBlobStream()); where conn.getBlobStream() is public InputStream getBlobStream() throws SQLException{ Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery( "select xdt.xls " + "from vw_ao_xls_dokumenti xdt " + "where xdt.id = " + dokument_id); if (rs.next() == false) throw new SQLException("Ne postoji dokument s danim id-jem"); Blob xlsFile = rs.getBlob(1); return xlsFile.getBinaryStream(); } so the value given to the Workbook factory is an InputStream of date acquired from the BLOB object. The creation af this workbook is the first call to anything in POI library, so my question is is there anything I could or should parametrize, like XMLOptions as stated in Bug 48936. Davor -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POIXMLException-reading-xlsx-tp4872709p4872862.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]
