无法使用PHPExcel&；代码点火器 - Cannot insert images using PHPExcel & Codeigniter

Cannot insert images using PHPExcel & Codeigniter

本文关键字：amp 代码点火器 PHPExcel | 更新日期: 2023-09-27

我在这部分遇到了一些问题。工作表中没有导出的图像。

$objDrawing = new PHPExcel_Worksheet_Drawing();
              $objDrawing->setName("logo_sci");
              $objDrawing->setDescription("logo_sci");
              $objDrawing->setPath('./assets/images/sucofindo_logo.PNG');
              $objDrawing->setCoordinates('C6');
              $objDrawing->setHeight(120); 
              $objDrawing->setWidth(120);
              $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

需要帮助！谢谢

此代码适用于我：

    if (file_exists('includes/temp/signatures/'.$id.'.jpg')) {
        $objDrawing = new PHPExcel_Worksheet_Drawing();
        $objDrawing->setName('Customer Signature');
        $objDrawing->setDescription('Customer Signature');
        //Path to signature .jpg file
        $signature = FCPATH.'/includes/temp/signatures/'.$id.'.jpg';    
        $objDrawing->setPath($signature);
        $objDrawing->setOffsetX(8);                     //setOffsetX works properly
        $objDrawing->setCoordinates('E38');             //set image to cell E38
        $objDrawing->setHeight(75);                     //signature height  
        $objDrawing->setWorksheet($this->excel->getActiveSheet());  //save      
    }

正如您所看到的，与您的代码不同的是setPath（）。需要是文件的根路径

注意：我使用PHPExcel作为Codeigniter的库。请参阅此处如何：http://fally.ro/using-phpexcel-class-with-codeigniter/