I've run into a bit of a snag parsing an XSSF Excel sheet. I'm not sure where the limitation lies, whether it's in the ooxml pieces or if it's something that the POI API could address. Perhaps someone that understands the stack could respond with some thoughts or insights?
Excel 2010 introduced a new ST_CellType - "d" for Date. This is described briefly on this page: http://msdn.microsoft.com/en- us/library/documentformat.openxml.spreadsheet.cellvalues(office.14).aspx I'm receiving an XSSF sheet that I need to parse that contains some of these cells. However, when I try to get the cell type or value from the cell, I get this exception: org.apache.xmlbeans.impl.values.XmlValueOutOfRangeException: string value ''d'' is not a valid enumeration value for ST_CellType in namespace http://schemas.openxmlformats.org/spreadsheetml/2006/main at org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.set_text (JavaStringEnumerationHolderEx.java) at org.apache.xmlbeans.impl.values.XmlObjectBase.update_from_wscanon_text (XmlObjectBase.java) at org.apache.xmlbeans.impl.values.XmlObjectBase.check_dated (XmlObjectBase.java) at org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.getEnumValue (JavaStringEnumerationHolderEx.java) at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.getT (Unknown Source) at org.apache.poi.xssf.usermodel.XSSFCell.getBaseCellType (XSSFCell.java) at org.apache.poi.xssf.usermodel.XSSFCell.getCellType(XSSFCell.java) I've worked around the issue for now, through casting my Cell object to XSSFCell and using getRawValue whenever this XmlValueOutOfRangeException is raised from getCellType, but of course it feels clumsy and fragile. It would be great to know if this could be enhanced/fixed more robustly and in what part of the API that would have to occur (the latter mostly just so I know where I should post the enhancement request!). Thanks everyone, great API by the way, very very handy! Dylan. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
