On Thu, 30 Apr 2015, João Miguel Penetra wrote:
This guide has been very useful and I've managed to reduce the memory
problems and optimize the performance but now I have issues parsing the
data. I have these two examples:
<c r="B2" s="3"><v>33015</v></c>
and
<c r="D2" s="1"><v>910000001</v></c>
In the first example I figured it out that I could
use HSSFDateUtil.getJavaDate in order to get a proper date but how can I
know I'm looking at a date and not other thing? How can I establish a
connection between the "s" attribute and the type of cell I'm looking at?
You'll need to look at the cell styles to work that out.
Two good examples of doing this are:
https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
https://svn.apache.org/repos/asf/tika/trunk/tika-parsers/src/main/java/org/apache/tika/parser/microsoft/ooxml/XSSFExcelExtractorDecorator.java
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
