How to validate whole column in phpexcel

Question

I am working on the phpexcel to create excel sheet and i have to validate that sheet for some columns. I tried for the below code

$objValidation = $objPHPExcel->getActiveSheet()->getCell('D1')->getDataValidation();

It gives me cell D1 validated but i want to validate whole column D validated.So what i have to do please help

score -2 · Answer 1 · edited May 23 '17 at 12:17

-2

foreach($j=2; $j<=10; $j++) {
   $objPHPExcel->getActiveSheet()->getCell("D$j")->setDataValidation(clone $objValidation);
}

edited May 23 '17 at 12:17

Community

answered Mar 06 '17 at 06:37

Riddhi Rathod

1

It will validate 10 cells only what we have to do to update whole column – varad mayee Mar 06 '17 at 06:43

1 Answers1