Answer the question
In order to leave comments, you need to log in
How to extract cell comments in phpexcel?
Good afternoon.
I need to pull out a comment (note) from a cell, I do it as follows:
echo (string)$worksheet->getCommentByColumnAndRow($row, $col)->GetText();
фывфффффффы sadssssasd 231 #$#%*(&@
DK2DDDDDDDK sadsss
Answer the question
In order to leave comments, you need to log in
It was decided by resaving the document from xls to xlsx.
XLS does not support comments even if they are saved and displayed in MsExcel 2007+
Converting from xls to xlsx:
$objPHPExcel = PHPExcel_IOFactory::load("XMLTest.xml");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('covertedXml2Xlsx.xlsx');
9_x0004_F_x0004_C_x0004_:_x0004_5_x0004_=_x0004_3_x0004_H_x0004_I_x0004_7_x0004_E_x0004_J_x0004_D_x0004_K_x0004_2_x0004_0_x0004_
В браузере отображается как:
9FC:5=3HI7EJDK20
И при копировании в блокнот++ между каждой буквой юникодный символ "EOT"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question