Answer the question
In order to leave comments, you need to log in
Remove hyperlink in Excel using PHPExcel?
Greetings!
I have a question about PHPExcel: I'm
processing a file, as a result, I need it the same but with hyperlinks, the old ones need to be deleted
$setURL='';
$objWorksheet->getCell("M".$row)->getHyperlink()->setUrl($setURL);
This option does not work
. I did not find anything in the documentation. Can someone come across such a question, tell me what can be done to remove the old link.
Answer the question
In order to leave comments, you need to log in
First, you write the text into a cell - then a hyperlink is written to this text:
$title='Qwerty';
$url='http://qwerty.com';
$objWorksheet->setCellValue("M".$row, $title);
$objWorksheet->getCell("M".$row)->getHyperlink()->setUrl($url);
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question