Hello.
I need to update reports in my project from old xls to xlsx. All files xls
are only layout. To create this xls reports we used POI lib (3.0). Because
there is no simple way to convert old xls file to xlsx I created own
converter which working fine for some simple reports. My converter basing on
XSSFWorkbook class (POI 3.7). How it’s all work
1. All xls file was opened in MS Office 2010 and saved as xlsx
2. Converter read xlsx file, to do this I used “XSSFWorkbook” class (and
standard java InputStream).
3. Converter iterates all rows and cells and put correct value to correct
cells.
4. Saving object XSSFWorkbook as a new xlsx doc.
All this working joust fine in my stand alone test but my project working on
WebLogic 9.2.3 and unfortunately I’m getting error in place where converter
start iterating cells and reading value (exception appear when I'm calling
toString on first cell).
The error is:
org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
at
org.apache.xmlbeans.impl.values.XmlObjectBase.check_orphaned(XmlObjectBase.java:1213)
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.getF(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFCell.getCellType(XSSFCell.java:454)
at
org.apache.poi.xssf.usermodel.XSSFCell.toString(XSSFCell.java:708)
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Converting-xls-to-xlsx-and-XmlValueDisconnectedException-on-WebLogic-9-2-3-poi-3-7-tp4424712p4424712.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]
