Reading multiple files with foreach

Topics: Developer Forum, User Forum
Apr 23, 2010 at 5:47 PM

Hello there.

I just recently started using your library, but I ran into some issues. My goal is to use your library, so I can process some data from multiple Excel files, and send such data to a database, per file. I'm doing something like:

foreach( $file_list as $file ) {

	$book = PHPExcel_IOFactory::load( $path . $file );

}

So, inside the foreach I'm also sending the current file-loaded data to the database, but after five files, I get a memory error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 50688 bytes) in /var/www/test/classes/PHPExcel/Shared/OLERead.php on line 76

Is there a way to __destruct the object after each file is loaded, so space is reserved (made free) for the next file, instead of accumulating it, or do you rather know of a work-around for this?

Please let me know any suggestions you have.

Thank in advance.