Set properties

Nov 10, 2010 at 5:24 AM
Edited Nov 10, 2010 at 5:32 AM

Don't work setting properties.  Do you have any solution?


require_once '../Classes/PHPExcel.php';

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
                             ->setLastModifiedBy("Maarten Balliauw")
                             ->setTitle("Office 2005 XLS Test Document")
                             ->setSubject("Office 2005 XLS Test Document")
                             ->setDescription("Test document for Office 2005 XLS, generated using PHP classes.")
                             ->setKeywords("office 2005 openxml php")
                             ->setCategory("Test result file");

// Set active sheet index to the first sheet, so Excel opens this as the first sheet

// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/');
header('Content-Disposition: attachment;filename="test.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');


Nov 10, 2010 at 11:38 AM

Writing Document Properties is not currently supported in the Excel5 Writer - Work Item 9759. This requires a change to the underlying OLE Writer to support the property streams

Feb 14, 2011 at 8:17 AM
Edited Feb 14, 2011 at 9:14 AM

Update: I hadn't noticed the Functionality Cross-Reference.xls document. My excuses, it's hard to grasp a full new library.


It'd be nice if stuff like this was documented somewhere and removed / commented out from the examples. It's frustrating to spend an hour trying to make a feature work just to find out it's not supposed to work.

Maybe something like this:

method setCreator [line 158]

PHPExcel_DocumentProperties setCreator( [string $pValue = ''])

Set Creator


access:   public
formats:  Excel5 (reader), Excel2007 (reader and writer)


string   $pValue  

[ Top ]