Will PHPExcel preserve existing form elements ?

Topics: Developer Forum
Jun 12, 2010 at 2:52 PM

I am filling in a spreadsheet that is provided as a template.

I read it using the EXCEL2007 reader, modify some cell values and then write it out with the EXCEL2007 writer.

And PHPExcel works fine EXCEPT that there are some Radio Buttons in the input spreadsheet which are not present in the output.

I have tried this just reading and then writing with no intermediate processing and still the Radio Buttons appear to be removed.

Is there something I can do so that the radio buttons are preserved ?

Test Code:

  $objReader = PHPExcel_IOFactory::createReader('Excel2007');  

  $objPHPExcel = $objReader->load($templatefilename);  

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


  The spreadsheet I am using can be found at : http://ec.europa.eu/environment/climat/emission/mrg_templates_en.htm and then select the English Report of Annual Emissions template.

Thanks in advance for any help on this - Chris Ringrow




Jun 14, 2010 at 7:56 AM

Forms are not currently supported within PHPExcel.

Jun 14, 2010 at 8:02 AM

Hi Mark,

Thanks for your reply.

So to just to clarify a Radio button on a spreadsheet ( not on a separate form ) is not supported in PHPExcel ? 

Regards Chris