You are faced with two choices really. The classes in the XSSF stream will allow you to read .xlsx files with ease but the drawback is, as you have found out, that it consumes memory. In order ot reduce the loading on the machines memory, you can use the event driven approach but this is not a trivial task and it will take a little effort on your part.
If you still want to use the event driven approach, then you will need to download one of the archives from the URL I supplied. Save the file onto your machine and then unzip it. When you have unzipped the archive you should find that there are a few JAR files there, one of which is called xercesImpl.jar. This is the archive that you will need to make available at compile/run time in order to execute the example code. I am not at all clear what the piece of code you posted means. What are the variables j, k, C, R and RECORD referring to? Are you trying to say that you want to recover a three dimensional array that contains the data recovered from a Workbook? If so, does the format applied to the contents of the cells matter to you or is the raw value sufficient? If using POI seems like it might be too much work, take a look at Tika - http://tika.apache.org/ - it is a project focused on developing techniques to extract the contents of various documents. It uses POI to handle Office documents and will read Excel workbooks. I have no experience with it and do not know if the OOXML files will be processed with the Event or User Models but it might be worth taking a look. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-works-but-it-uses-too-RAM-is-it-a-limit-of-your-library-tp5712425p5712488.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
