Failing to save

Topics: Developer Forum
Jul 21, 2011 at 3:11 PM

Hi guys,

version    1.7.6, 2011-02-27

I have a script creating a largeish (500 Kbyte) and complex sheet.

It appears to be failing at the save stage.

Here's the relevant bit of script:

error_reporting(E_ALL);
require_once 'Classes/PHPExcel.php';

$objPHPExcel = new PHPExcel();
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_serialized;
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;
PHPExcel_Settings::setCacheStorageMethod($cacheMethod);
.
.
# Code to populate the spreadsheet
.
.
debugprint("about to write spreadhseet $filename\n");
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
debugprint("Created Writer, about to save as $filename\n");
$objWriter->save($filename);
debugprint("about to chmod spreadhseet $filename\n");

The output from the script is:

...

about to write spreadhseet /var/www/vhosts/vetgrad.com/httpdocs/statistics/20-07-2011-clickthroughratios.xlsx
Created Writer, about to save as /var/www/vhosts/vetgrad.com/httpdocs/statistics/20-07-2011-clickthroughratios.xlsx

Then nothing else. The save appears to be failing, and no error messages.
The script has worked, but has become increasingly unreliable as the data in the spreadsheet has grown - memory issue?
Any help greatly appreciated.