PhpExcel Image

PhpExcel Image

<?php
 error_reporting(-1);
 ini_set('display_errors', 'On');
 require_once(dirname(__FILE__).'/vendor/PHPExcel.php');
 $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_sqlite3;
    if (!PHPExcel_Settings::setCacheStorageMethod($cacheMethod)) {
        die($cacheMethod . " caching method is not avaiLabel" . EOL);
    }

    $objPHPExcel = new PHPExcel();
    $objPHPExcel->getProperties()->setCreator("RKM");
    $objPHPExcel->getProperties()->setLastModifiedBy("RKM");
    $objPHPExcel->getProperties()->setTitle("Thumbnail");
    $objPHPExcel->getProperties()->setSubject("Thumbnail");
    $objPHPExcel->getProperties()->setDescription("Thumbnail.");
    $objPHPExcel->setActiveSheetIndex(0);
    $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
    $objPHPExcel->getActiveSheet()->SetCellValue('B2', 'world!');
    $objPHPExcel->getActiveSheet()->SetCellValue('D2', 'world!');
    $objPHPExcel->getActiveSheet()->setTitle('Thumbnail');
    $gdImage = imagecreatefromjpeg('logo.jpg');
    $objDrawing = new PHPExcel_Worksheet_MemoryDrawing();
    $objDrawing->setName('logo.jpg');
    $objDrawing->setDescription('Thumbnail');
    $objDrawing->setImageResource($gdImage);
    $objDrawing->setRenderingFunction(PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG);
    $objDrawing->setMimeType(PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
    $objDrawing->setHeight(50);
    $objDrawing->setCoordinates('A1');
    $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('excel/test.xlsx');
?>