How to remove/overwrite a comment in a PHPExcel cell?

Question

phpspreadsheet

Good afternoon!
I use PHPExcel to work with Excel.
It is necessary to overwrite the comment in the cell, but it turns out only to append to the end with this code:

$objPHPExcel = PHPExcel_IOFactory::load('./test.xlsx');
$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun("testtesttest"); 
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
$objWriter->save('./test.xlsx');

How all the same to overwrite or delete the comment in the necessary cell?

Answer 1

You need to use the setText() method :

$objPHPExcel = PHPExcel_IOFactory::load('./test.xlsx');
$comment = $objPHPExcel->getActiveSheet()->getComment('E11');
$commentText = new PHPExcel_RichText;
$commentText->createText("testtesttest");
$comment->setText($commentText);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
$objWriter->save('./test.xlsx');