php link whole column

Topics: Developer Forum, Project Management Forum, User Forum
Apr 2, 2015 at 9:40 PM
One of the col of my db has the full path of a image including http:// ....
instead of showing the full path may i create a hyperlink? for all?
I've finded only for one row...not for all
->setCellValue('B'.$rowNumber,$row->photo)
Coordinator
Apr 2, 2015 at 9:54 PM
Apr 3, 2015 at 9:57 AM
Yes but that its for one CEL i have all the B row start with B12 and its end up when no rows in db will be , and the link of each cell its different..
Apr 3, 2015 at 9:59 AM
its should be like
$objPHPExcel->getActiveSheet()->setCellValue('B'.$rowNumber,$row->photo)
$objPHPExcel->getActiveSheet()->getCell('B')->getHyperlink()->setUrl('$rowNumber,$row->photo');

but dosnt work...