phpexcel在Codeigniter中不擅长图像

Question

foreach ($table_columns as $field) {
    $object->getActiveSheet()->setCellValueByColumnAndRow($column, 1,
        $field);
    $column++;
}
$feedbackInfo = $this->export->employeeList();
$excel_row    = 2;
foreach ($feedbackInfo as $row) {
    $object->getActiveSheet()->setCellValueByColumnAndRow(0, $excel_row, $row->teacherid);
    $object->getActiveSheet()->setCellValueByColumnAndRow(1, $excel_row, $row->serial);
    $object->getActiveSheet()->setCellValueByColumnAndRow(2, $excel_row, $row->name);
    // $object->getActiveSheet()->setCellValueByColumnAndRow(3, $excel_row, $row->photo);
    if (file_exists('./uploads/teachers/photos/teacher-' . $row->teacherid . '.' . $row->photo . 'TH.jpg')) {
        `problem is here i want to export with image`
        {
            $object = new PHPExcel_Worksheet_Drawing();
            $object->setPath('./uploads/teachers/photos/teacher-' . $row->teacherid . '.' . $row->photo . 'TH.jpg');
            $object->setCoordinates(3, $excel_row);

            $object->excel->getActiveSheet()->getRowDimension($excel_row)->setRowHeight(120);
        } else {
            $this->excel->getActiveSheet()->setCellValueByColumnAndRow(3,
                $excel_row, '');
        }

        $object->getActiveSheet()->setCellValueByColumnAndRow(4, $excel_row, $row->email);
    }

    $object->getActiveSheet()->setCellValueByColumnAndRow(5, $excel_row, $row->password);
    $object->getActiveSheet()->setCellValueByColumnAndRow(6, $excel_row, $row->phone_number);
    $object->getActiveSheet()->setCellValueByColumnAndRow(7, $excel_row, $row->teacher_pin);
    $object->getActiveSheet()->setCellValueByColumnAndRow(8, $excel_row, $row->created_at);
    $excel_row++;
}

//passvalueonobject
$object_writer = PHPExcel_IOFactory::createWriter($object, 'Excel5');
             header('Content-Type: application/vnd.ms-excel');
             header('Content-Disposition: attachment;filename="teacher Data.xls"');
$object_writer->save('php://output');
      }
         }

Answer 1

I thought the problem may be in image path. Please give a FCPATH for image.

$signature = FCPATH.'/uploads/teachers/photos/teacher-' . $row->teacherid . '.' . $row->photo . 'TH.jpg';

or

$signature = base_path().'/uploads/teachers/photos/teacher-' . $row->teacherid . '.' . $row->photo . 'TH.jpg';

The another problem is Specifying coordinates.

Specifying coordinates for the image might help, as per the examples and the documentation.

$object->setCoordinates('A3');

Note that an image isn't in a cell/column/row, but overlaid over the main sheet at the same position as that cell/column/row

source 1

source 2