PHPExcel insertion of images in the note



  • As PHPExcel inserts the image into the xlsx file(s) note, i.e., that the bay is replaced by colour:

    $objPHPExcel->getActiveSheet()->getComment('E13')->getFillColor()->setRGB('EEEEEE');
    

    In EXCEL, this is:

    ActiveCell.AddComment.Shape.Fill.UserPicture (ImaFile)
    


  • //Выводим картинку
    $objDrawing  = new PHPExcel_Worksheet_Drawing(); 
    $objDrawing->setPath('картинка.png'); 
    $objDrawing->setCoordinates('A1'); 
    //$iDrowing->setWidth(30); 
    //$iDrowing->setHeight(30);
    $objDrawing->setOffsetX(35);
    //$iDrowing->setRotation(25);
    $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
    



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2