Paul, I searched for the event model programming in POI, but I ended up with "POIFS" that is actually a filesystem event model to read and write. But I need an event model to handle multiple sheets in one file. I hope you understand what I am saying ....same like what SAX doest on multiple elements of XML.
One more options I was thinking to increase the maximum heap size, but again if my file size exceeds 50MB then it will create a problem. Any idea? Regards Awais Bajwa -----Original Message----- From: Dobson, Paul L CTR USAF AFMC 416 SCMS/OBN [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 12:35 PM To: POI Users List Subject: RE: Out of Memoary Error while reading an EXCEL file I was having the same problem. I ended up using the event driven model to parse the file. Then there is no limit on file size. -----Original Message----- From: Awais Bajwa [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 10:34 AM To: 'POI Users List' Subject: Out of Memoary Error while reading an EXCEL file Hi Folks, I have an excel file that has many sheets and many rows, my requirement is to pick a specific cell from one row. But when I load the file that is 54MB of excel file. I get an Out of memoary Error at: fileSystem = new POIFSFileSystem (inputStream); Any thoughts??? Any limitation of POI? Regards Awais --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
