CODEWITHSUNDEEP
phpexcel
user3585448
user3585448

Reputation: 17

Export Excel multiple image with PHPExcel

i want export excel from php with PHPExcel. My excel contain multiple image but only one image can view. How can i view the others image? this my code 

    $objDrawing = new PHPExcel_Worksheet_Drawing();
    $objDrawing->setName("name");
    $objDrawing->setDescription("Description");

    $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

    $logo = "application/views/templates/default/img/Mutiara.jpg";
    $objDrawing->setPath($logo);
    $objDrawing->setHeight(96);     
            $objDrawing->setCoordinates('A1');
            $objDrawing->setCoordinates('H1');

Upvotes: 0

Views: 2978

Answers (2)

Rogerio de Moraes
Rogerio de Moraes

Reputation: 1577

$assign = $line; 
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing->setPath('application/views/templates/default/img/Mutiara.jpg');
$objDrawing->setCoordinates('A'.$assign.'');
$objDrawing2 = new PHPExcel_Worksheet_Drawing();
$objDrawing2->setWorksheet($objPHPExcel->getActiveSheet());
$objDrawing2->setPath('application/views/templates/default/img/Mutiara.jpg');
$objDrawing2->setCoordinates('H'.$assign.'');

Upvotes: 0

Mark Baker
Mark Baker

Reputation: 212412

An individual drawing object can only have one coordinate; so taking one drawing object and setting the coordinate to A1, then setting it again to H1 is still only a single drawing object.

Once you've created the drawing object and set its main properties, clone it so that you have multiple copies, each of which can be set to different coordinates

$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName("name");
$objDrawing->setDescription("Description");

$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

$logo = "application/views/templates/default/img/Mutiara.jpg";
$objDrawing->setPath($logo);
$objDrawing->setHeight(96);     
$objDrawing->setCoordinates('A1');

$objDrawing2 = clone $objDrawing;
$objDrawing2->setCoordinates('H1');

Upvotes: 1

Related Questions