[FIXED] How to load excel template and write to it in PHPExcel?

Issue

How do I load an Excel Template with PHPExcel and write to its cells and also insert images to cells dynamically?

Solution

You can read your excel template like this with PHPExcel:

$objPHPExcel = PHPExcel_IOFactory::load("./forms/english/cash.xlsx");

and you can write to cells like this:

  $objPHPExcel->setActiveSheetIndex(0)
                            ->setCellValue('A2', "No")
                            ->setCellValue('B2', "Name")
                            ->setCellValue('C2', "Email")
                            ->setCellValue('D2', "Phone")
                            ->setCellValue('E2', "Address");

Answered By - MJ X

Answer Checked By - David Goodson (PHPFixing Volunteer)