It is only fairly infrequently that people use the event driven approach as it does have some limitations and lacks some of the support - such as evaluating formulas - that you find in HSSF and XSSF. The advantage is, of course, a lower memory overhead but this does mean that you will have to create and maintain two code bases - one for the OOXML files and another for the binary ones. In addition, you will have to identify which type of file you are dealing with and use the appropriate codebase for it. At it's most trivial, you can simply look at the name of the file and if it ends in .xlsx or .xlst or .xlsm then use the SAX parser event driven approach to process it and if it ends in .xls or .xlt then use the HSSF event driven approach.
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-read-large-excel-file-using-apache-poi-tp5712649p5712659.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]
