editing an Excel 2007 document with PHPExcel

Question

I have en excel 2007 document with 10 sheets but when I try to edit it with PHPExcel all the contents of those sheets (except the first one and the input made with PHPExcel) are erased.

Here is my code:

require 'PHPExcel.php';
require 'PHPExcel/IOFactory.php';
require 'PHPExcel/Writer/Excel2007.php';

$fileType = 'Excel2007';
$fileName = 'test.xlsx';

$objReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objReader->load($fileName);

$activeSheet = $objPHPExcel->setActiveSheetIndexbyName('ID');
$activeSheet->setCellValue('A2', 'string test');

$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save($fileName);

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

By looking at this post try rearranging your code like this:

require 'PHPExcel.php';
require 'PHPExcel/IOFactory.php';
require 'PHPExcel/Writer/Excel2007.php';

$fileType = 'Excel2007';
$fileName = 'test.xlsx';

$objPHPExcel = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objPHPExcel->load($fileName);
$objPHPExcel->setActiveSheetIndexbyName('ID');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'string test');

$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save($fileName);

edited May 23 '17 at 11:58

Community

1
1

answered Oct 09 '13 at 04:34

Automate This

29,798
11
58
80

Thank you for your answer but I get the error message : Fatal error: Call to undefined method PHPExcel::setLoadAllSheets() – user2741700 Oct 09 '13 at 04:37
Thanks but now i have the error message : Call to undefined method PHPExcel_Worksheet::getSheetByName() – user2741700 Oct 09 '13 at 04:51
Sorry I'm not able to test but here is one other idea: $objPHPExcel->setActiveSheetIndexbyName($sheet['ID']); – Automate This Oct 09 '13 at 05:08

editing an Excel 2007 document with PHPExcel

1 Answers1