PHPExcel Comment

Question

I am trying to insert a comment into a cell. I am trying to use the code for comments, but it does not show the comment in excel created. I am creating the .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("\r\n"); $objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('Total amount on the current invoice, excluding VAT.'); 

Answer 1

There are no comments on the Excel5 entry. Use the Excel2007 creator to create the .xlsx file.