Using notes in excel

Topics: User Forum
Nov 30, 2009 at 10:09 AM

Excel allows you to add notes to cells, much like the alt tag in html. I have not found any indication whether phpexcel supports this. Can someone clarify this for me?

Many thanks

Dec 1, 2009 at 10:46 AM
Edited Dec 1, 2009 at 10:47 AM

Hello,

PHPExcel supports it but it does not seem to work with Excel5 Writer : (I started a discussion about this problem : http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=76409 )

to add a note :

 

$workbook->getActiveSheet()->getComment('B2')->setAuthor('me');
$workbook->getActiveSheet()->getComment('B2')->setVisible('true');
$workbook->getActiveSheet()->getComment('B2')->getText()->createTextRun('TEST COMMENT');