Hello, first of all let me apologize in case this is not the correct place for this question. I have been having trouble parsing a XLSX file with 10 MB without having OutOfMemoryError issues. I've searched around and found your guide regarding the SAXParser ( https://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api). 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? The second example is a cellphone number but it also qualifies as a valid Excel date by using this method: HSSFDateUtil.isValidExcelDate Best Regards, João Penetra
