Hi,
I want to generate excel files from a template:
-
Open an Excel file
-
Filling a few cells
-
Save the file
I found this extension PHPExcel. But I think it lacks that thing.
Is possible with the original extension :
$objPHPexcel = PHPExcel_IOFactory::load('template.xlsx');
$objWorksheet = $objPHPexcel->getActiveSheet();
$objWorksheet->getCell('A1')->setValue('John');
$objWorksheet->getCell('A2')->setValue('Smith');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPexcel, 'Excel5');
$objWriter->save('write.xls');
Any idea?
Thanks and regards.