PHPExcel评论

Question

I am trying to insert a comment with in a cell. I am trying following code to comment but it is not showing comment within created excel. I am creating .xls extension.

$objPHPExcel->getActiveSheet()->getComment('E11')->setAuthor('Efusionsoft');
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('PHPExcel:');
$objCommentRichText->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun("
");
$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('Total amount on the current invoice, excluding VAT.');

Answer 1

There is no support for comments in the Excel5 writer. Use the Excel2007 writer to create an .xlsx file.