A
A
Alexander Lead2015-11-30 00:18:25
PHP
Alexander Lead, 2015-11-30 00:18:25

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

1 answer(s)
P
Pavel Zamoroka, 2015-12-03
@zapashok

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 question

Ask a Question

731 491 924 answers to any question