How to write in an existing excel file?

[hellreaper]

Hello,

 

I have an template excel file and for each of my users in my data base i need to be able to create a different excel file.  If anyone could guide be i would really appreciate it.

 

Thanks

[Mark Baker]

Read the excel file into PHP using a library such as PHPExcel. Modify the cells that you wish to personalise, and write it out as a new Excel file

[hellreaper]

Thank you for your reply,

 

I didn't find any information on how to read an existing excel file and writing in it with PHPExcel, I just found how to create a file here  http://g-ernaelsten.developpez.com/tutoriels/excel2007/

[Mark Baker]

I didn't find any information on how to read an existing excel file and writing in it with PHPExcel[/url]

You didn't look very hard

 

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

$objPHPExcel = PHPExcel_IOFactory::load("excelTemplate.xls");

$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'World!');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('excelCustomised.xls');

[hellreaper]

i really suck because i cant find were you found that info.....

[hellreaper]

Ok i found how to do it thank you!

 

 

^{include 'Classes/PHPExcel/IOFactory.php';}

^{$objReader = PHPExcel_IOFactory::createReader('Excel2007');}

 

^{//we load the file that we want to read}

 

^{$objPHPExcel = $objReader->load("test.xlsx");}

 

^{//we change the file}

 

^{$objPHPExcel->getActiveSheet()}

^{->setCellValue('A1','EEEEEEEEE')}

^{->setCellValue('A2','DDDDDDDDDDDD')}

^{->setCellValue('A3','CCCCCCCCC')}

^{->setCellValue('A4','BBBBBBBBBB')}

^{->setCellValue('A5','AAAAAAAAAAAAA')}

^{->setCellValue('A29','MaitrePylos');}

 

 

^{//we create a new file}

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

 

^{//we save}

^{$objWriter->save('coco.xlsx');}

 

[cancer10]

HI Guys,

 

hellreaper's code worked like a charm. But If you try to read a file  with formulaes  for example if you add the formula

 

=SUM(B1,B2,C1,D2) somewhere in the file, then the new generated file will be generated with reversed GUI.

 

PFA excel file for example.

 

 

Does anyone have any idea how to fix this?

 

[attachment deleted by admin]